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: 3
Thanks: 1
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,489
Thanks: 85
Thanked 1,458 Times in 1,376 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: 2,541
Thanks: 29
Thanked 626 Times in 609 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
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: 10,749
Thanks: 40
Thanked 3,484 Times in 3,371 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
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 05:10 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