Open Form

[Guest_imported]

I have a Main form that can display all record. I also have a subform that allow user to add new recordset to the table.
The question that I have is how to open a main form with the new record that just added to the subform.
Below is the function:

Private Sub cmdAddNew_Click()
On Error GoTo Err_cmdAddNew_Click

'close my subform after new record is added to table
DoCmd.Close
'Close mainform to refresh data
DoCmd.Close acForm, "Mainform", acSaveYes
'Reopen the main form with the new added record
'This line is not working right.
DoCmd.OpenForm "Mainform",acViewPreview,
"Combo439 = " & LineNumber

End Sub

Any helps would be greatly appreciated.

 

[Rohdem]

If the data that is entered on the subform is displayed on the main form, why do you need a subform? Why can't you enter the data on the main form?

Mike Rohde
rohdem@marshallengines.com

 

[Guest_imported]

I used the wizard to create the combo box and it only display records that are already in the table.So whenever I type a record that is not in the table, It gives me an error message said that the record is not in the list. So I need a subform in other to add a new record.But when I close the subform, I want the main form to open with the new record that I just added. So I don't have to scroll down the combobox to select the new added record.

thanks,

 

[Rohdem]

If I am understanding you correctly, this should work.

forms!mainformname!combo439.requery
forms!mainformname!combo439 = me.linenumber
Docmd.close 'close subform

This should also eliminate the need to close and reopen your subform

Mike Rohde
rohdem@marshallengines.com