Populating data when opening form

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

Guest

Hi

I am having a problem with a form that i have created. Within this form
there are certain lookup fields based on the change event command which
populates different answers within other fields depending on what is
selected. When i am in the database and go from one record to the next the
populated information remains but when I shut down the database and restart
the database the fields in the form that require populating are blank. Is
there a code that will help me populate the fields without having to reselect
the fields in order to populate on change.

thanks

Úna
 
Una,
In order to give a better response, it would have been helpful if you had
given an example of how "a field gets changed, and others are updated".
What happens on the "change" event (perhaps you mean AfterUpdate event)?
How do you populate the related fields?
What are the ControlSources of those updated fields?

Sounds like those fields you are populating aren't "bound" to fields in
your table. That's why you lose the values when you close and reopen the
form. If you truly do need to save these "related" values, the
ControlSource must be a field in your table.

Post back with more detailed information, and I'm sure someone can give
you a more detailed answer, but I'm pretty sure that's your primary problem.

hth
Al Camp
 
Back
Top