Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
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
Old 06-13-2019, 12:04 AM   #2
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,663
Thanks: 99
Thanked 1,501 Times in 1,416 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: multi field lookup

Sounds like it is a classic Cascading Combo structure.

You would need to requery the combo on the Current Event to change its Row Source.
Galaxiom is offline   Reply With Quote
Old 06-13-2019, 04:18 AM   #3
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,947
Thanks: 57
Thanked 1,297 Times in 1,278 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: multi field lookup

Hi. One solution is to overlay a Textbox on top of the Combobox bound to the same field.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 06-13-2019, 08:38 AM   #4
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,334
Thanks: 40
Thanked 3,670 Times in 3,538 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: multi field lookup

if you are talking about cascading combo's in a continuous form then you might find this link helpful

https://www.access-programmers.co.uk...d.php?t=275155
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Reply

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 11:04 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