J
Joe
Hello,
I have created a form which has three text boxes and each
of these text boxes refer to different tables, which are
linked through primary and foreign keys. When I attempt to
type in one of the text boxes, it does not let me. I have
checked the properties and made sure that the text box was
enabled and that it is not locked. The record source for
the form is a plain select statment to include the three
fields from their correlating table. I am able to type in
the other two boxes. I also have the form running a macro
where "On Open" it is to "GoToRecord" "New". I believe the
issue is with the macro, since when I remove the macro I
am able to type into the text box. If anyone can provide
me with some insight on what the main issue is that would
be great. What I am attempting to do is to be able to open
this form and have the text boxes on the last record of
the tables to be ready for input from the text boxes.
Thank you.
I have created a form which has three text boxes and each
of these text boxes refer to different tables, which are
linked through primary and foreign keys. When I attempt to
type in one of the text boxes, it does not let me. I have
checked the properties and made sure that the text box was
enabled and that it is not locked. The record source for
the form is a plain select statment to include the three
fields from their correlating table. I am able to type in
the other two boxes. I also have the form running a macro
where "On Open" it is to "GoToRecord" "New". I believe the
issue is with the macro, since when I remove the macro I
am able to type into the text box. If anyone can provide
me with some insight on what the main issue is that would
be great. What I am attempting to do is to be able to open
this form and have the text boxes on the last record of
the tables to be ready for input from the text boxes.
Thank you.