Search results for query: *

How can I create a macro (or Code) to automate a filtering of a form. I found how to do this by picking advance filters but need to make this easier for users. My form name is Order Details and the field I want to filter is Customer ID. Any help will be appreciated. Thanks

Thanks! Now it works! Thanks so much.

Thanks lameid. What I am trying to do is this: I have a form "Order Details" inwhich using a combo box I select a line of cabinets that the estimate is for ("Line"). On the subform I select the Product ID and need the "Unit Price" to lookup the "Price" in the table which corresponds to the...

I have this expression: = IIf(forms![Order Details]![Line]=[Oakhill Sq],then [Unit Price]=DLookup("[Price]","[Oakhill Sq]","[Product ID]='"&[Product ID]&"'")) It tells me that expression contains invalid syntax. What have I done wrong?

What does this error mean?

Thanks. Read the article and it was a great help. Making changes to my database now.

Thanks for your interest. I have the following tables: Jobs, Estimates,Line, and about 20 tables of different lines of products. I have not set a primarily key to any tables. The Jobs table has only one field [job], Line table lists all available lines with only one field [line]and the estimate...

I have a table named tblEstimates, a form named frmEstimates, and a field named Estimate#. How can it get the form to automatically assign a new number to each new estimate? In case you need to know the form has a sub form in it and the parent/child link is the field Estimate#. Thanks for any help.

Thanks!!! It is working now. Bless you!

Thanks Randy but that generates #Name error. If I place a product id value as in ='2424P'") it works but I need it to be able to look up the values.

I have a subform (Estimates1) in a form (Estimates) that I am applying the DLookup to data source. =DLookUp("[Price]","[Oakhill Sq]","[Product ID]=[Me].[Product ID]") I am trying to find the price in table Oakhill Sq that matches the Product ID on my subform. It returns #Error. What am I doing...