Can a Pop up form update the main form?

  • Thread starter Thread starter Tom K via AccessMonster.com
  • Start date Start date
T

Tom K via AccessMonster.com

Hi,
I have a main form which I use to display records from a table. There is a
control button on this form to open a new entry form which I use to enter new
records into the table. The main form stays open in the background while the
new entry form is open. When I close the new entry form and go back to the
main form I would like to see the form updated with the new record that I
just entered. I would also like to have that new record be the current record
displayed.

I know that I can Requery the main form on close of the new entry form, but
that does not take me to the new record that I entered. Also I dont want it
to filter to only show the new record, I want to have all records accessible
but just go to the new one.

Is there any way to do this with a macro?

Thanks,
Tom
 
Tom

An alternate approach would be to use your command button to change the
form's data entry property, then change it back when you "save" the new
record. This would save you having to pop up a form for entry.

JOPO (just one person's opinion)
 
Tom

If you are familiar with using VBA and writing code (e.g., for the command
button), you'd use the property that lets your form serve as a data entry
form.

If you aren't comfortable doing this, you may need to get comfortable doing
this <g>. What it sounds like you are trying to do will probably require
that you do some coding.
 
Back
Top