Message box pop up with condition

  • Thread starter Thread starter Frankie via AccessMonster.com
  • Start date Start date
F

Frankie via AccessMonster.com

Hi there,

I have the following issue to resolve :
2 forms (A and B)linked to tables thru queries.
Form B has some fields auto populated from Form A's table as soon as you
select a name from a listbox (which is a query on Form's A table.
The problem is that each time you modified Form A records you need to go to
Form B to reselect the name from the listbox so that it updates form B 's
auot populated fields.
So I thought of making a mesage box that would pop up any time a change is
made on form A records.
Since I am not an expert I would appreciate some guidance as to what would
best fit my needs.
Or maybe there is a better way than a pop up ??
Thank you in advance.
Frankie
Access 2003
 
First: Are FormA and B opened at same time?
if yes, you can use Requery method to update FormB after FormA updated
asume you have a Save button in FormA
The code for this button:

Docmd.Runcommand acSaveRecord
With Forms!FormB
.Requery
!YourField.SetFocus
End With

i hope it can help you


Rainbow01
from Hong Kong

"Frankie via AccessMonster.com" 來函：
 
First: Are FormA and B opened at same time?
if yes, you can use Requery method to update FormB after FormA updated
asume you have a Save button in FormA
The code for this button:

Docmd.Runcommand acSaveRecord
With Forms!FormB
.Requery
!YourField.SetFocus
End With

i hope it can help you


Rainbow01
from Hong Kong

"Frankie via AccessMonster.com" 來函：
 
Back
Top