How to link two textboxes in different forms together?

[PoorCadaver]

Hi!

I have a form that recieves information from a table. In that form I have a button that opens another form, and in thet one I would like to use one of the values from the first form.
I.e. Form1 have a textbox [ID1] that contains "1". In Form2 that opens from Form1, I would like the textbox [ID2] to use the value from [ID1], namely "1". How do I link them together?

Thanks!

/Jonas

[imintrouble]

What is the second form based on? is it the same table the two are based on?

[PoorCadaver]

No it's another table, but the ID is the same in both tables. Form2 is an adding-form that will use the ID in Form1 to put in another table.
One table contains a list of equipment and the other is a list of service reports.

[PoorCadaver]

Bumping =)

[R_Badger]

To Clarify:

You have two tables:
First for equipment (I shall now refer to this as [Tbl_Equipment], and assume the primary key is [PK_ID1])
Second for service reports (I shall now refer to this as [Tbl_Service_reports] with a foreign key being [PK_ID1], named in the tabls as [ID2])

You have two forms:
First for equipment using [Tbl_Equipment] as its recordsource. I shall Call this [Frm_1]
Second for service reports on the aforementioned equipment using [Tbl_Service_reports] as its recordsource. I shall call this [Frm_2]

You have a command button, with either visual basic or a macro to open on [Frm_1] to open [Frm_2] in order to add a new record.

You want the value in [PK_ID1] on [Frm_1] to be placed into a field [ID2] on [Frm_2] When [Frm_2] is opened.

The solution:

1. In [Frm_2] goto design view.
2. Right click [ID2]
3. Click Properties
4. Click Data
5. Click Default Value
6. Change to read; =[Forms]![Frm_1]![PK_ID1]

That *should* do it unless I have misunderstood.

[PoorCadaver]

Well, that was very helpful! But it only seems to work with ID that are digits. Those ID containing letter gets an #error.
Also, when I try to save the new post it says: "You can't add or alter the post. A relatedpost in Tbl_Equipment is required."
So what to do? I can't figure it out by myself =(