passing a field back to a form when using not in list 1

[christine4]

I have a form with a combo box that when not in list goes out to another form to add it then comes back to the first form. When it comes back I need to also pass back a department field to the first form. Can't seem to get this to work. If I am not entering a new item I can bring in the department but if entering a new item I can't get it to work.

Any ideas?
[sig][/sig]

 

[jimmythegeek]

Why don't you create a public variable to assign the department to while you are on the second form? When you come back, you just refer to that variable. [sig]<p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development[/sig]

 

[Umbane]

Check to see that the department is included in the data source so that when you requery the control it requeries the department as well.

Umbane
[sig][/sig]

 

[Lightning]

Christine
I use the following code to do this. It is run from the CloseForm event of the second form.

Private Sub cmdCloseForm_Click()
On Error GoTo Err_cmdCloseForm_Click

'If main form is open, close current form and
'return focus to the main form.
    DoCmd.Hourglass True
    If IsLoaded("MainForm") Then
        Dim X As Variant
        X = Me![AccountNumber]
        DoCmd.Close acForm, "CurrentForm", acSaveYes
        Forms!MainForm![AccountNumber].Requery
        DoEvents
        Forms!MainForm![AccountNumber] = X
        DoCmd.Hourglass False
    Else
    'Otherwise, close this form
        DoCmd.Close
        DoCmd.Hourglass False
    End If

The IsLoaded function is not a built-in Access function, but is included in the Northwind sample database that comes with Access. You can copy it from there into a module in your app.

Hope this helps
Lightning
[sig][/sig]

 

[christine4]

Thanks for your help.

Lightning 4 that worked great. [sig][/sig]