Coding After Update

[Guest]

Can anyone help me figure out what to put in after update in event for combobox to get it to pull record from a different table than the form is based upon? I have a table listing all employees for different stores. I have a query that asks which store and pulls all the relavent files. I also have a form based upon the query for the stores, but after the user puts in the store name, I would like to have a combobox for the Last Name to pull the record the user needs to modify. Please help

Thanks in Advance!

 

[Cheryl Fischer]

Rachel,

Are you asking how to have your second combo box of Last Names limited to
those employees at the Store selected in the first combo box? If so, here
are two articles which explain how:

How to Synchronize Two Combo Boxes on a Form
http://support.microsoft.com/default.aspx?scid=kb;EN-US;289670

ACC: How to Synchronize Two Combo Boxes on a Form (97624)
http://support.microsoft.com/default.aspx?scid=kb;[LN];97624



--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

Can anyone help me figure out what to put in after update in event for

combobox to get it to pull record from a different table than the form is
based upon? I have a table listing all employees for different stores. I
have a query that asks which store and pulls all the relavent files. I also
have a form based upon the query for the stores, but after the user puts in
the store name, I would like to have a combobox for the Last Name to pull
the record the user needs to modify. Please help!

 

[Guest]

Thanks Cheryl - However, I tried the first method using the sample database Northwind and am still unable to get the second box to pull the information. I was able to get it to fill with numbers (possibly record ID's) but not the actual list of products. I was thinking that the row source might be incorrect - according to the article the row source on the second combobox is blank. Any additional help?