Update 2nd Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nylex - 23 May 2007 03:19 GMT

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

Reply to this Message

John W. Vinson - 23 May 2007 07:13 GMT

>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
[quoted text clipped - 4 lines]
>When I entered the new purchase price and a new Selling Price is calculated
>I then need to update the ITEMS form also

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]

Reply to this Message