Combobox Value in Form2 is Automatically Selected Based on Last Entry in Form1

[dodicrossanda]

Dear Masters,



I'm a newbie. I've got situation and has been simplified as mention below,

FORM1:
- CompanyID (TextBox)
- Prefix (TextBox)
- CompanyName (TextBox)
- Suffix (TextBox)
- Phone (TextBox)
Button:
- &Add New PIC (Opening New Record of form FORM2)
- &Edit PIC (Opening Edit of form FORM2)

FORM2:
- PICID (TextBox)
- CompanyName (ComboBox:

SELECT [CompanyID], [Prefix] & ". " & [CompanyName] & " " & [Suffix] FROM FORM1 ORDER BY [Prefix] & ". " & [CompanyName] & " " & [Suffix];

- Division (TextBox)
- Title (TextBox)
Button:
- &New (New Record)
- &Delete (Delete Record)
- &Close (Close form)

Question:
- How to configure Combobox on FORM2 automatically select its respective CompanyName(Order by Prefix. CompanyName Suffix) which just being recorded from FORM1 after clicking Add New PIC's Button on FORM1 ?

Thank you for your ideas and suggestions.

Best regards,

Dodi

[June7]

Is this a form/subform arrangement? What is purpose of these forms? Why do you need the company name selected in form 2?

Want to provide db for analysis? Follow instructions at bottom of my post.

[dodicrossanda]

Is this a form/subform arrangement? What is purpose of these forms? Why do you need the company name selected in form 2?

Want to provide db for analysis? Follow instructions at bottom of my post.

Hello June7,

This is a form arrangement. I am sorry that I forgot to mention about field "PICName" on FORM2. FORM1 is company database and FORM2 is PIC(Person In-Charge) database. The purpose of these forms are:
- record company database
- record PIC (Person In-charge) in each of recorded companies where each of them probably may have more than 1 PIC.
So, once I've finished making a new entry in company database then I wanna go straight to make new record for PIC by clicking its button on FORM1. Currently, once FORM2 is opened and I start to make new record for PIC...it shows only fresh blank form with combobox not automatically selected. What I mean here is, I wanna make new entry without selecting/ scrolling down the dropdown list of combobox. I also have attached the file. I hope this would help to explain what I meant. Thank you June7 for your response.

Best regards,

Dodi
SampleComboBox.zip

[June7]

The easiest solution is form/subform arrangement. The PIC form would be a subform on the company form. The Master/Child links properties of subform container will synchronize related records. The company primary key will automatically save to the PIC record. No code needed. However, for this to work, you need to save the companyID into PIC table, not company name because the ID is set as the PK. Even if you don't use form/subform and the forms remain independent, the PK should be saved.