add to lookup cbobox / autofill on close of entry form?

B

Brook

Good Day All,

I have a frmmileage that I use for tracking mileage on my business trips
and have have a cbobox cbomileageaddress that I lookup to my
tlbmileageaddress, however if I need to add a value (Company,City/State), I
double click the cbomileageaddress which opens a frmaddentry. After I add my
new Company & City/State and click "OK" I want my fields on my main
frmmilelage to automatically update so that the user doesn't have to select
the new value from the cbobox?

Any ideas / suggestions?

Hope this is clear..

Thanks,

Brook
 
J

Jeff Boyce

Brook

Another approach is to use the NotInList event of the combo box. This would
still trigger the popup form for entering the new value, but would
re-load/pre-load the newly-created value on return.

Check Access HELP on NotInList.
 
B

Brook

Jeff..

Thanks for the response, so I should use the NOTINLIST to open the form.

I will try that... and will post a response.

Brook
 
Top