Accessing data from one form and using it in another form

[Kevin DeBiasse]

I have a main form with a list of items and qty in stock. User clicks on the
item type user who took it leaving qty minus 1. I want the main form to
subtract the number from the qty left of other form

 

[Rastro]

If it helps I send the information from the current form to the main instead
than try that main collect it.

Something like this:

Private sub Form_Modal_Close_Click()

Forms("Name of Form_Main").Controls("Name of the control")=Value 'in
this case: value=qty - 1
docmd.close

End sub

 

[Kevin DeBiasse]

Lets start over Sorry.
I have a form with inventory of Kegs. It has the total we have on site.
User clicks on keg that they want. It goes to another screen with the name of
Keg and a subform where a user enter a name and qty of kegs taken it could be
1 to 5. I then want that keg info be subtracted from total. IE keg rootbeer
total 4, user requests 2 kegs then main screen shows total 2.

Thank you.

 

[strive4peace]

Hi Kevin,

it is important to realize that the data is in TABLES not forms ...
forms give you a convenient way to edit and display data stored in tables...

for better understanding of the basics of Access, read this:

Access Basics (on Allen Browne's site)
http://www.allenbrowne.com/casu-22.html
8-part free tutorial that covers essentials in Access

Allen has a wealth of information on his site; after you get to the
bottom of this link, click on 'Index of Tips'

Warm Regards,
Crystal



*
have an awesome day
*