Multiple tables with the same value

[Desverger]

What I have so far is 3 forms. One form has 2 buttons to open 2 other forms.



Each form has a text box with this =[Forms]![Service Ticket Information]![Service Ticket No] To show what ticket the form is for.

How can I have this value be saved in the tables in the 2 other forms?

Do I need to add the field to the form? If so, how do I populate this field with the correct value?

Thanks.

[TheShabz]

well, first off there are no tables in the other 2 forms. the other 2 forms are merely displaying the data that is in a table. to change what the form displays, you have to INSERT INTO, UPDATE, or DELETE FROM the table(s) it is referencing.

so, are you updating or creating a new record? I'm going to assume creating a new record. Run the following query

INSERT INTO myTable (data1, data2, serviceTicketNo)
VALUES (value1, value2, [Forms]![Service Ticket Information]![Service Ticket No])

note the syntax (google "MS Access Insert Into" for more info). Now that you have entered the data into the table, your other 2 forms will be able to display it. Whether they do so depends on how the other 2 forms are set up.

[Desverger]

There are tables in the other 2 forms. I am not sure if that changes your answer or not.

[TheShabz]

the tables are not located in the form. you may be displaying the information from the tables in the forms, but i assure you, there are no tables stored within forms. The point I was getting at is that you do not have to change the forms in order to change the data being displayed. The query above will take whatever value is stored in that textbox, and insert it into the table of your choice. the form that is referencing the table will then display it.

[Desverger]

Ah, gothca. Sorry I think was having a senior moment on reading about the other 2 forms not having tables and yes the forms only display the values.

I will give this a try and reply with either good news or bad.

Thanks.