Update 2nd Form

N

Nylex

I have a form where I enter in an Item no
When I enter a number I need another form , that is allready opened, to
change and show the details on the new item no that I have just entered
The form that I am entering details in is called PURCHASES and the form that
has details is called ITEMS

When I entered the new purchase price and a new Selling Price is calculated
I then need to update the ITEMS form also
 
J

John W. Vinson

I have a form where I enter in an Item no
When I enter a number I need another form , that is allready opened, to
change and show the details on the new item no that I have just entered
The form that I am entering details in is called PURCHASES and the form that
has details is called ITEMS

When I entered the new purchase price and a new Selling Price is calculated
I then need to update the ITEMS form also
Click to expand...
Without knowing what tables underly these forms, how they are related, etc.
it's hard to be specific - but the most likely solution is to make the details
form a Subform of the main form.

Bear in mind that data (prices, items) are *NOT* stored in Forms, but in
Tables; forms are just windows onto the table data.

Have you looked at the Northwind sample database's Orders form?

John W. Vinson [MVP]
 
Top