Sync'd combo boxes must update recordset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I did search to see if anyone had a previous solution and I didn't find anything....my apologies if it is a repeat

I have a subform that has two combo boxes, each combo box must update the keyfield to the underlying recordset, how can I sync combo box 2 to only list the categories in combo box 1 but still have the the recordset hold the keyfield from both combo boxes??

NOTE: If i set combo boxes with a "Bound Column" I only get the first category in combo box 2 (which is what one would expect)

HEL
Thank
Cath
 
I'm not clear as to what you want but I think I understand.
I often have a combobox display a contact name. This information comes from
to fields of a table contact.FirstName & contact.LastName. I concatinate the
fields using Name:contact.FirstName & " " & contact.LastName in the query's
Field box of the query builder from the row souce property of the conrtol.
You can use this same approach to use both pieces of information to create
your Keyfield.
Cathi said:
I did search to see if anyone had a previous solution and I didn't find
Click to expand...
anything....my apologies if it is a repeat.
I have a subform that has two combo boxes, each combo box must update the
Click to expand...
keyfield to the underlying recordset, how can I sync combo box 2 to only
list the categories in combo box 1 but still have the the recordset hold the
keyfield from both combo boxes???
NOTE: If i set combo boxes with a "Bound Column" I only get the first
Click to expand...
category in combo box 2 (which is what one would expect).
 
Thanks Bill, not too sure that solution will work for me let me see if I can give better detail. Maybe it's just that my brain isn't working anymore as I have thought of this way too much ;-

On the subform, which is a continuous form that can hold many different departments each with a category and also same department - different categories, I have a combo box for Dept and a combo box for Category. I need to store the PKey for each of those within my PatDetail records. However if I sync the combo boxes I can't set a "bound column". The other problem I have is that I need to alway display what the record holds after the update of the combo boxes. I also need to make this as few of clicks and easy as possible for the user
 
Back
Top