Microsoft access Subform and Not in List

[PANMOR]

Hi
I have one main form and two subform. all three comes from three different table which are linked to ID. on main form I have Combo box and Date registered field. By selecting ID in combo box the subform shows data for that ID. If there is new ID not in list event fires and pop up form appears where i can enter date registered for that ID and on closing the form it enters new id to all three tables. However i can not go into combo box and select new ID to complete subform. I have to close the main form and than open again to fill in subform for that new ID. I like code so that i do not need to close main form. Please help.

 

[RuralGuy]

What ComboBox are you having trouble with and where is it located?

(RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro
Please respond to this forum so all may benefit

 

[TheAceMan1]

How are ya PANMOR . . .

The [blue]NotInList[/blue] event should automatically requery the combobox. Does the new [blue]ID[/blue] show in the combobox?

If your still having problems, post the code for the [blue]NotInList[/blue] event and post the relationships for the three tables (parent/child).

Are the form/subForms linked with the [blue]master/child[/blue] link properties?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[TheAceMan1]

PANMOR . . .

Hit submitt too soon ... post the names of the forms.

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Zazi69]

Hi, im facing same issue. I have a form and subform linked with one singe ID. I wish to add the not in list to be able to add new entries not in the combo box that holds the ID and be able to add the new data in the two linked tables.

The databse manages Customers and Orders. So I have:

Main form: Customer
Sub form: Orders

master/child link properties: joined by Customer ID

Problem: I wish to be able to add a new Customer from this form/suborm, using not in list, without the need for a new form for a new form for Customer data entry. As well as add orders for this new customer not originally in the table Customers nor his ID is in the Customer combo box.

Any help would be appriecated.