Can I use a secondary form to enter data into a main form?

[Nicole]

I'm creating a database for a Catering company who only
has a select menu. Is it possible to create a pop up form
for the users to select the menu items to enter into the
Main form? (eg, Bob places an order for an order of
Eggplant Parmigiana and Fried Calamari, can a pop up form
display these items with check boxes and when the user
selects the two items it pulls them back into the new
order?) I hope I've explained myself clear enough. I
appreciate any help I can get!!! Thank you!!

 

[John Vinson]

I'm creating a database for a Catering company who only
has a select menu. Is it possible to create a pop up form
for the users to select the menu items to enter into the
Main form? (eg, Bob places an order for an order of
Eggplant Parmigiana and Fried Calamari, can a pop up form
display these items with check boxes and when the user
selects the two items it pulls them back into the new
order?) I hope I've explained myself clear enough. I
appreciate any help I can get!!! Thank you!!

Well... one concern here. It sounds like you're trying to store
information IN A FORM. You can't! The Form is just a tool to store
information in a Table. You can certainly pop up a form to update the
Order table, but you already *HAVE* a form to update the order table -
what (other than making the customer repeat themselves, saying 'yes I
really DO want Calamari, why are you asking me again?') benefit does
the second form serve?

 

[Nicole]

John:
Thank you for your response. I apologize for my lack of
clarity....the "Main Form" I was referring to is only a
method for entering records into an underlying table.
The "Pop up form" would be a tool for data entry into
the "order" table via check boxes on a form. The users
who will be working with this database don't want to have
to search through a List (combo box) to find items and
they don't want to type because they aren't too quick.
They feel it would be easier to hand write at that point
(UUUGGGGHHH). I hope I'm clearer this time.
Sincerely,
Nicole