Open a Form which populates specific data from another form

[daniboi]

Hi Guys,



I have a pop-up Form (For creating Maintenance Tickets). It contains a button for Creating a Work Order for that ticket.

I would like that Button to Open the Work Order Form and populate relevant info from the ticket form (such as customer info and ticket description) so i don't have to retype everything.

Any direction or help would be appreciated. This is my first post so if i did something wrong please let me know.

[aytee111]

You pass filters between forms. formA has a field with a value, formB has a record source that contains that value. Open formB from formA using that value as a filter:
VBA or macro.

[daniboi]

Thanks for your quick reply although i am not sure if that would help with what i am trying to visually achieve. Please see the enclosed image with a bit of description to portray what i am trying to achieve...The highlighted fields in #1 Form (Tickets) should be populated when i click on Create Work Order (#2).

[aytee111]

Why wouldn't it work? User enters information on form 1 and the data is displayed thru the record source for form 2. You will have to save the record when they click on the button so that the data will be available for when form 2 is opened.

[daniboi]

Can you kindly direct me to where i can learn about passing filter between forms so i can attempt to apply your suggestion?

[jwhite]

Have you created code to create the new Work Order before opening the Work Order form?

If not, you need to do that! Hopefully you have a unique field for WorkOrderNumber.
On click of the Create button, build SQL statement to add the new record to the Work Orders table, execute it with CurrentDb.Execute, and then open the Work Orders form with the Where argument set to the WorkOrderNumber.

[aytee111]

In form design, click on the button, find the OnClick property and add either a macro or an event procedure. Which would you prefer to use? Either one will give you the same result altho VBA is more versatile.

[daniboi]

I am like at the bottom-est pit of beginners when it comes to coding...so i apologize for the lack of knowledge and to answer your question no coding has been done so far...that "Create Work Order" button only opens the Work Order Form at the moment...

came across this (http://www.baldyweb.com/wherecondition.htm), would i be able to use this?