Continuous Form Value Lookup

[acollier]

I have two continuous forms. Depending on the current selection in the first
form, I would like to show a limited set of values in the second form for the
user to choose from based. The values are part of a parent/child or
master/slave database relationship. For example, the first firm would allow
the user to enter mountain or street bicycle. As they select the options
for the bike in the second form, the options such as tire type would only
display for the type of bike selected in the first form. Currently, I can
get multilayers of forms to work, but each layer displays all options making
it confusing for the user. I've worked on this for five days - PLEASE HELP!!!
!

 

[Klatuu]

Use a query for the second form's record source that is filtered on the value
of the matching field name in the first form.
Then in the Current event of the first form, requery the second form.

 

[Ron2006]

Use a query for the second form's record source that is filtered on the value
of the matching field name in the first form.
Then in the Current event of the first form, requery the second form.
--
Dave Hargis, Microsoft Access MVP





- Show quoted text -

Another way but basically the same thing but does not require you to
issue the requery yourself.

You apparently have an unbound found (although it could be bound to
something).(I will call it "Main Form".)

Place an unbound txtbox on that form and your two other forms. These
forms I will call Parent form and Child form.

In the OnCurrent event of the first selecting form (the Parent Form)
move the value for the parent child relationship to the main form
unbound field.

In the "Form Property" of the 'Child Form' type in yourself the
matching key for the child form and the name of the unbound field of
the Main Form as the master field. If the Main form is NOT bound to a
table or query you will have to do this yourself since the parent
child wizard will NOT execute.

Ron