dlookup

A

at100

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
 
K

Ken Snell

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

QBF & Query Malfunction 0
DLookup in Continuous form 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Automation of scanned file storage based on content 0
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
VBA Legacy Drop Down Not Working 0
combo box filter 1
Access 2007 - Macros Not Working Properly 4

Top