pass values to a form from multiple forms

I

Ira

Can someone help me on this? I have a form with 3 text boxes: Category,
Service, Activity. There are command buttons by each of them that open 3
different forms. After I open Category form, add and save new value, I use
Open Arguments to pass ID value into previous form. How can I pass IDs from
open and save from Service and Activity forms? It seems to be a conflict in
Open Args. Thank you very much in advance.
 
A

Anand

Hello Ira,
You could try to achieve this by writing code in each of the category
service and activity forms to update the main form. You could achieve this
with some simple lines of code.

Try entering/updating the main form after the save command in each of the
sub forms. You could also achieve this by updating the background table in
the sub forms. If the fields in the Main form are linked to the same fields
in the table - they get updated automatically

HTH
Anand
 
I

Ira

First of all Thank you Anand for your help.
The problem is that all 3 forms that I want to open from main form have
record source from 3 different tables. I want to be able to create a new
record in each of these tables and pass newly created IDs into main table as
one record. For example: create category ID in the category table as "1",
service ID in the service table as "1", and activity ID in the activity table
as "1". Then I want to create record in the reference table with all these
IDs. Thank you again.
 
I

Ira

Does anyone have any idea how to pass values from 3 different forms into one
form into 3 different boxes? I would appreciate any help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top