Help Needed

[AngryPanda]

I'm having a bit of trouble with my database, and i really need some help.
For my database I want what is illustrated in the attached image;

I've managed to do the first part; searching through tables and loading a form for the desired data entered in the txtsearch, but I can't seem to be able to create the 'add' part. I've looked all over the place, for tutorials, examples or even small snippets of coding, no luck though.
If anyone could please help me it would be very much appreciated!

Thanks in advance.

Ps. Sorry if this wasn't the right place to post the thread.

 

[Ron_dK]

... but I can't seem to be able to create the 'add' part.

I'm not sure as to what you want to achieve. What is the add part doing ?
Adding a new record or ?

 

[AngryPanda]

I'm not sure as to what you want to achieve. What is the add part doing ?
Adding a new record or ?

Well, the 'add' button is to add the selected record (in this case cheese pizza) in the loaded form to the order subform. So, orders can be added and deleted from the subform without being deleted from the actual table itself...
Hope that makes sense..

 

[KeithG]

Are saying you don't want the recorded added to the table until the user hits the add button? Is that your problem?

 

[AngryPanda]

anyone got any ideas?

 

[Epic]

Under Add button
Forms("PizzaOrder").Form.forms("PizzaOrderSubform").Form.Pizza = ME.Pizza
Forms("PizzaOrder").Form.forms("PizzaOrderSubform").Form.Type = ME.Type
etc..
Or something like this... use the code builder from a separate form to get the above

Thıs way you can refer to any open forms...
!!! It will update the active record but not save