Updating Records in Form

[Guest]

I have a listbox on a form that contains the primary key for all of the
records that are contained in the table that the form is based on. Much like
the "Find a record on my form based on the value I selected in my combo box"
combo box option.

The problem is after I create a new record (clicking a button opens a
separate form to enter the information) the listbox updates with the new
record, however the new form does not. For instance, having 3 records, I add
a fourth and the form still indicates only 3 records in the navigation bar.

When I close and open the form manually, the record is recognized however if
I close and open the form in code it doesn't work. I have also tried to
requery the form, i'm not sure if that should work or not. I'm not sure what
requerying a form does or if it queries the records as well.

thanks in advance,

 

[tina]

answered in your subsequent post of a little over an hour later. once you
post a question in a newsgroup, recommend you wait at least a day before
abandoning that thread and posting the same question again, whether in the
same group or another one. otherwise, you may end up with different people
giving you the same or similar answers in both threads, which wastes server
resources and the time of everyone involved.

hth