Combobox Find A Record Based on Value Selected

[Zaxxon]

Hi I just started working with multiple tables and relationships (woo big step), but I'm having trouble with recalling records now.

I have a form for editing records. There's a combobox on the form that lets the user picks the record they want to edit and it brings up all its related information in textboxes below for editing. I made the combobox using the wizard and selecting "Find A Record On My Form Based On The Value I Selected In My Combo Box".

Now though I have two tables that are in a one-to-many relationship. When I create a form using fields from both the tables, I no longer have the "Find A Record On My Form Based On The Value I Selected In My Combo Box" choice in the wizard.

Is there a way to still do this?

My second table only has two fields (an ID and text; the ID is in the relationship with the first table's ID field). I was hoping to create a single form (like the one I had before) and not have to use sub-forms.

 

[pbaldy]

IIRC, the wizard will only display that option if the form is bound to a table. The same code may still work though. Copy it from a working combo and adjust the field/control names as appropriate.

That said, it's probably more common to display a one-to-many relationship with a form (one) with a subform (many).

 

[Zaxxon]

Hmm ya I tried copying it but no luck. When I change the number in the combobox nothing below changes.

When I use a subform the combobox works perfectly. The only reason I would rather not use a subform though is for looks and ease of use. The subform looks a little more confusing and takes up more space than a single textbox.

I'll play around with it and see if I can improve its look.