didnt work so far guys.

[Guest]

http://www.microsoft.com/office/com...&p=1&tid=b662f900-79f6-4594-96b4-bb15344dd6a4

 

[David Lloyd]

I am not sure what version of Access you are using, however, have you tried
the combo box's NotInList event? The following KB article gives more
details on its usage.

http://support.microsoft.com/default.aspx?scid=kb;en-us;197526

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


http://www.microsoft.com/office/com...&p=1&tid=b662f900-79f6-4594-96b4-bb15344dd6a4

 

[Guest]

thanks so much for all guys. i will try this and get back to you.

 

[Guest]

thanks david but that code looks like way too much for this small problem!
when i add an item to the list table - that works great. when i go back to
combo - it is not there until i click in the combo box. i just want to see
if i can do that without refreshing. thanks!

 

[Guest]

Did you try
Change INPUT_FRM.MFG.Requery to Me.MFG.Requery. Why do you open the
ADD_MFG_FRM form twice? You can remove the second.
If so what errors are you getting? Please provide more information on what
is going wrong.

 

[Guest]

schast -
the first form is a record input form. the form uses a combo box for input
to restrict the user.
if what they are trying to input is not in the combo box - they hit a button
on bottom of form that says "add/delete info in combo boxes". they would hit
that button if what they are trying to input was not there.
when they hit the button it takes them to another form that has 8 separate
ares (mfgs, items, cat# etc) with two buttons for each. one button says "add
mfg" and the other says "del mfg".
the user decides which option they want (in this case "add mfg") and presses
another button to go to the "add mfg" form.
that form simply has a text box with a save record button to press when done
and an exit button which goes back to original input form.
everything works fine but when going back to input for - the newly entered
info is not automatically there. you need to click on the list to update.
just curious if i can use event to update that combo list so that it would
be there when going back to list in input form.

thanks man!

 

[Guest]

What event do you have the requery statement at? It sounds like you may need
to move it. Or maybe a refresh statement , but that should not be needed.

 

[Guest]

Error-

The expression you entered refers to an object that is closed or doesn exist……

-

here is code – this is on the close event of the mfg input for that takes
you back to main input form. T hanks man. So much help. I am almost there.

Private Sub Command28_Click()
On Error GoTo Err_Command28_Click

DoCmd.Close

DoCmd.OpenForm "INPUT_FRM", , , , , acDialog
Me.MFG.Requery



Exit_Command28_Click:
Exit Sub

Err_Command28_Click:
MsgBox Err.Description
Resume Exit_Command28_Click

End Sub

 

[Guest]

Try this code:

Private Sub Command28_Click()
On Error GoTo Err_Command28_Click

DoCmd.Close

Fprms![INPUT_FRM]![MFG].Requery

 

[Guest]

Had a typo:
Forms!....

 

[Guest]

YOU - ARE AMAZING! works like a charm man. i thank you
sooooooooooooooooooooooo much! all of you. made my day. i feel as though i
should give all of you money! hahah! thanks again.

Try this code:

Private Sub Command28_Click()
On Error GoTo Err_Command28_Click

DoCmd.Close

Fprms![INPUT_FRM]![MFG].Requery

Error-

The expression you entered refers to an object that is closed or doesn exist……

-

here is code – this is on the close event of the mfg input for that takes
you back to main input form. T hanks man. So much help. I am almost there.

Private Sub Command28_Click()
On Error GoTo Err_Command28_Click

DoCmd.Close

DoCmd.OpenForm "INPUT_FRM", , , , , acDialog
Me.MFG.Requery



Exit_Command28_Click:
Exit Sub

Err_Command28_Click:
MsgBox Err.Description
Resume Exit_Command28_Click

End Sub