When added a record wil automatically can be chosed in other form

[Frank Situmorang]

Hello,

I have the member data which can be added in a form. This table has the
child filed of Address ID in from the PK of Address table.

When I add a member data and found in its combo there is no the address yet,
at the same time I open the address form and I add the address, then go back
to member data on address I have a problem that if the address data is
current ..in the address form, I can not see it in the member update form, we
should return to the previous record then we can see it in the member form.

My question is how can we make it even though the record of address is
current in the address form, we can still view and add it in the member
update form.

Thanks for any help.

Frank

 

[Arvin Meyer [MVP]]

There is a NotInList event that allows you to use one of the 3 constants to
resolve for problem

acErrDataAdded, acErrDataContinue,acErrDataDisplay

I have a generic NotInList event on my website which will show how to code
for the problem:

http://www.datastrat.com/Code/NotInListCode.txt

and there is a sample database that demonstrates how to use the code:

http://www.accessmvp.com/Arvin/NotInListDemo.zip

 

[Frank Situmorang]

I have tried your demo/sample Marvin, but the problem is still the same, that I have to move from the new record in the Customer form, then I can see it in the combo of Event form.

What do you think I missed.

Moreover what is the meaning of bFlag Marvin. I am not sure if you understand my problem. My problem is that I can only see new record of household name of the address form, in the combo of member data, when I move forward or backward. Meaning to say if the new address record being current in the address form when we just add, it can not be seen in the member's address combo.

Thanks for your help.

Frank



Arvin Meyer [MVP] wrote:

There is a NotInList event that allows you to use one of the 3 constants
19-Dec-09

There is a NotInList event that allows you to use one of the 3 constants t
resolve for proble

acErrDataAdded, acErrDataContinue,acErrDataDispla

I have a generic NotInList event on my website which will show how to cod
for the problem

http://www.datastrat.com/Code/NotInListCode.tx

and there is a sample database that demonstrates how to use the code

http://www.accessmvp.com/Arvin/NotInListDemo.zi
-
Arvin Meyer, MCP, MV
http://www.datastrat.co
http://www.mvps.org/acces
http://www.accessmvp.com

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Enums in XAML And Root Addressing For Images
http://www.eggheadcafe.com/tutorial...a-01bb29ea4e02/wpf-enums-in-xaml-and-roo.aspx