Weird Form Updating problem

  • Thread starter Thread starter Phil M.
  • Start date Start date
P

Phil M.

In some of my subform records in an access database, I have VB code that
allows me to bring up a more detailed form based on the record.

For example, I have a subform that lists just a few key fields of a table.
When I double click on the record with the key fields, it brings up a more
detailed form with the record.

Here is the problem: Let's say I added a new record in the list view. I
then want to double click on the record to bring up the full view of the
record. However, what happens is it brings up a blank record without my
additions!! I have to click OUT Of the record, then back in, and then double
click. Annoying!

Is there some way I can like.. make the database UPDATE before it runs the
code to enter the full view form?

PS. the above probably makes no sense

Phil M.
 
Sounds as if you need to do a requery of the list box after you add the new
item. In your code, after you add the new item to the table on which the
listbox is based, put this (change generic name to real name) code as the
last step:

Me.ListBoxName.Requery
 
Phil M. said:
In some of my subform records in an access database, I have VB code that
allows me to bring up a more detailed form based on the record.

For example, I have a subform that lists just a few key fields of a table.
When I double click on the record with the key fields, it brings up a more
detailed form with the record.

Here is the problem: Let's say I added a new record in the list view. I
then want to double click on the record to bring up the full view of the
record. However, what happens is it brings up a blank record without my
additions!! I have to click OUT Of the record, then back in, and then double
click. Annoying!

Is there some way I can like.. make the database UPDATE before it runs the
code to enter the full view form?
Click to expand...

Add a single line of code to the event that opens the form.

Me.Dirty = False
 
Back
Top