Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 06-12-2019, 09:55 PM   #1
jmills
Newly Registered User
 
Join Date: Jun 2019
Posts: 7
Thanks: 2
Thanked 0 Times in 0 Posts
jmills is on a distinguished road
multi field lookup

I have a continuous form sub-form embedded on multi-table data entry form. The sub-form has 3 fields. The first is a look up field that gets its list from a query that works fine. The second lookup field needs to get its list from a query with a criteria based on field 1. My query works for the first record in the sub-form. However for all the subsequent records, field 2 only shows the lookup list associated with field 1 in record 1. Any idea how I can get the criteria for the second query to reset after each new field 1 is populated?

Thanks for your help

JRM

jmills is offline   Reply With Quote
 

Tags
continuous form , form , lookup field

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding Columns on Subform Based on Multi-Value Lookup Field cavemanderson Forms 3 08-08-2013 05:59 PM
lookup field using another multi value lookup field as data source effebruno Tables 5 11-25-2012 06:23 PM
multi-value lookup fields display all values tjones Forms 9 02-13-2012 10:32 AM
Multi-select Lookup Bug ?!? Need some help here... Brett Forms 2 10-14-2011 09:34 AM




All times are GMT -8. The time now is 09:33 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World