Create new record, open form populated with that info

[JackieEVSC]

I have a from with a combo box that populates other records in the form based on the choice. I need to code a button on that form that creates a record in an existing table and opens that record on different form, which they would then add addtional information. I'm sure it's not as difficult, but I've tried everything and it's not working. Can anyone direct me to a resource to help me with this? Thanks.

[June7]

The table is not part of the form's RecordSource? Use INSERT sql action to insert record to that table. In VBA could use CurrentDb.Execute "INSERT INTO table name (fieldnames) VALUES(values)"

Then code to open form and move to the last record or filtered to a specific record.

Or simply open form to new record. Then set values of fields with code.
DoCmd.OpenForm "FormB", , , , acFormAdd
Me!fieldname = somevalue

[JackieEVSC]

Thanks ... I'm closer!! The new form opens, but I wasn't able to code it properly to get the form populated. I need it to open where the field TicketNum (in the repair table, which this button populated) that corresponds with an unbound text field (Text60) in the form I'm leaving.

Here is my code ...

DoCmd.OpenForm "frm_RepairTicket", , , , acFormAdd
Me!TicketNum = Text60

I changed it to ...
DoCmd.OpenForm "frm_RepairTicket", , , , acFormAdd
Me!Text60 = TicketNum

But it still didn't work. I'm not a programmer, and I'm sure it's something silly I'm doing. Everything I do is by trial and error, and it's an arduous journey!

[June7]

I should have clarified how to use the code for setting field values.

In the second form Open event:
Me!TicketNum = Forms!form1name.Text60

The 'Me' qualifier can only be used to reference the form/report the code is behind.

Is it possible you could use a form/subform arrangement with these two forms?

[JackieEVSC]

I'm familiar with sub-forms and use them frequently, I'm just not sure how that will work with this. Let me briefly explain what I'm attemting to do and see the sub-form is what I need.

The StudentInfo form opens with a combo dropdown with a list of student names, studentID, their school, and the asset and serial tag number(s) of any netbook/laptop assigned to them (a student can have more than one assigned if their original is in for repairs, etc.). The information for this combo pulls from a query against a SQL based library database and an AS400 mainframe database.

That information, as well as a new repair ticket number (Text60) is on this form.

We have 24 schools that assign netbooks/laptops to students. I chose to incorporate the repair ticket number because the student with that same unit could be in the repair table already, and I wanted it to go specifically to the record created with that repair ticket number. The ticket number and the auto-number primary key in the new record are the only unique identifiers in the new record.

Am I making this more complicated that it needs to be?

[June7]

Need to know more about data structure. I presume linked tables are read only? Save the computer ID to ticket table. What table is the second form bound to, where is the TicketNum being saved by that form?

Do you want to provide project for analysis? Make copy, remove confidential date, create surrogate tables for the linked tables, run Compact&Repair, zip if still large, attach to post.