dlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to open up a form based on a table and restricting the records to a field on the main form.

Ex. main form has a drop down combo box based on company names in company table, once you choose the company the company form opens up filtered or restricted to just the companies chosen on the main form drop down..trying to use dlookup thinking thats the way to go using a macro open form.. but having problems..please help
 
Use the WHERE argument of the OpenForm action instead.
[FormFieldToBeFiltered]=[Forms]![FirstFormName]![ComboBoxName]

--

Ken Snell
<MS ACCESS MVP>

at100 said:
I am trying to open up a form based on a table and restricting the records to a field on the main form..

Ex. main form has a drop down combo box based on company names in company
Click to expand...
table, once you choose the company the company form opens up filtered or
restricted to just the companies chosen on the main form drop down..trying
to use dlookup thinking thats the way to go using a macro open form.. but
having problems..please help
 
Back
Top