Am I on the right track?

  • Thread starter Thread starter Samantha
  • Start date Start date
S

Samantha

I have created a table (Project Info Table) that has
several fields as well as: Consultant, Type and Fee
I have created a form based on the project info table but
because it has so much info on it I thought I would create
a separate form for the consultant info. I have done this
and added a command button on the project info form that
opens the consultant info form. I have the record source
for the consultant info form as being the project info
table. When I click on the command button, the form opens
and I am able to select the info I want. However, when I
go to close it I get error messages that it can't be saved
because the other required fields in the project info
table are filled in.

How can I set it up correctly so that I can open the
consultant info form from the project info form and the
info will tie in correctly?

Thanks in advance,
Samantha
 
Samantha said:
I have created a table (Project Info Table) that has
several fields as well as: Consultant, Type and Fee
I have created a form based on the project info table but
because it has so much info on it I thought I would create
a separate form for the consultant info. I have done this
and added a command button on the project info form that
opens the consultant info form. I have the record source
for the consultant info form as being the project info
table. When I click on the command button, the form opens
and I am able to select the info I want. However, when I
go to close it I get error messages that it can't be saved
because the other required fields in the project info
table are filled in.

How can I set it up correctly so that I can open the
consultant info form from the project info form and the
info will tie in correctly?
Click to expand...

There are lots of issues when trying to open two forms against the same
record simultaneously. I would lose the separate form and add a TabControl
to your original form so you can add more controls to it and keep
everything on a single form.
 
I started from scratch and recreated the consultant info
form and made a replaced the command button on the project
info form. Somehow this has fixed one problem - I am no
longer getting the error message regarding required
fields. However, when the consulant form opens, it always
opens to the first record. Is there a way to make it
correspond with the record on the project info form and to
also make it open to a blank form if the project info form
is a new form?

Rick: Thanks for your suggestion regarding the tab. I
already have several tabs for other things and was really
hoping to get the command button to work in hopes that the
user will be sure to fill in this info if available. (This
group needs all of the extra help it can get!)
 
Back
Top