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

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

Guest

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
 
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.
 
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
 
Back
Top