T
Tom Oberhofer
I have a simple form consisting of four text fields from two tables
(primary - foreign key relationship):
Form layout:
Textfield1-Table1 Textfield2-Table1 Textfield1-Table2
Textfield2-Table2
My problem is, that I cannot enter data into the text fields of the second
table, after having entered data into 'Textfield1-Table1 Textfield2-Table1'.
It goes like this:
To add a new record to the form, I open a second form and select a record. I
close the form using a button and with the button (on click) I pass to the
form I started from:
DoCmd.GoToRecord , , acNewRec
Forms!Formname![NumberString] = NumberAsString
Forms!Formname![TitleString] = TitleAsString
This works perfect and the values are copies to the form I started from
(fields of table 1). But then, when I want to complete the record (fields of
table 2), I cannot enter data into Textfield1-Table2 Textfield2-Table2.
The data is shown properly when the records have been manually added to the
tables.
Please help!
Thanx a lot in advance!
Tom
(primary - foreign key relationship):
Form layout:
Textfield1-Table1 Textfield2-Table1 Textfield1-Table2
Textfield2-Table2
My problem is, that I cannot enter data into the text fields of the second
table, after having entered data into 'Textfield1-Table1 Textfield2-Table1'.
It goes like this:
To add a new record to the form, I open a second form and select a record. I
close the form using a button and with the button (on click) I pass to the
form I started from:
DoCmd.GoToRecord , , acNewRec
Forms!Formname![NumberString] = NumberAsString
Forms!Formname![TitleString] = TitleAsString
This works perfect and the values are copies to the form I started from
(fields of table 1). But then, when I want to complete the record (fields of
table 2), I cannot enter data into Textfield1-Table2 Textfield2-Table2.
The data is shown properly when the records have been manually added to the
tables.
Please help!
Thanx a lot in advance!
Tom