Recent content by Milad

Thanks for your quick response. Following is the list of my columns for both tables : Employee#, WorkDate, CutNum, StyleNum, StyleColor, WorkAllocation Data For the first table : 712, 8/9/2013, 223344, IT300, Blue, ManualOperator Data For Second Table : 712, 8/9/2013, 445588, IT500, Yello...

Hello, I have a linked table that gives me 10 columns, and I also have another table with the same number of columns. These two tables are having 7 columns the similar but data are different. I have a columns which indicates that from which table the data come from. I am not able to build a...

To Part Hartman: Thanks for your response. I have everything same as yours but I am not sure what causes the problem.

That is right. Is this a problem?

to Part Hartman: I don't have any control source for my combo box and there is no table or query linked to it. It is actually just a combo box which show a Vendor list.

to CJ_London: I double checked it again and it was fine

I have a query that I referenced it to a combo box in a form. In my form I created a combo box which has a list of VendorName and I want my query to opens a VendorName report based on whatever chooses in the combo box so that I use the combo box name in the criteria of the VendorName in my...

I figured it out. I referenced my combo box to a wrong table. Thanks for your quick response BTW. :)

Sorry for late response, I just got your feedback. I just found a solution for it. I created a combo box in a sub form to give me a list of "style" for a specific "cut#" and then I used the combo box to restrict my "Fabric#". It is not a perfect way but it works for me fine. I should thank...

Unfortunately I can not do that. System designed in a way that only staff who are in the office are permitted to open databases not anywhere else due to data confidentiality. Even if I send it, you would not be able to open the file. I am pretty sure I can fix it if you could let me know how to...

Did you mean in the query's criteria? Because that's where I had my previous code.

Hello, I am trying to do the same thing for another form but somehow it does not work. can you help me out please. Thanks in advance

Thanks. Where should I add this code??

What you sent me is exactly same as what I used but unfortunately it does not work. I think it's because even the "style" value fill in automatically based on the "cutting#" but I am not sure.

In fact, I want to reference the "Style" field in the query which gives me the "FabricNum"