Combo Box Woes

[caustin0]

Hi all,

Using Access 2000...My DB is tied to a sql table (which in turn is popualted by a web based form) when my users are accessing the Access form, I have a combo box tied to a field in the sql table. If someone submits a new record via the web based form the new value does not appear in the combo box unless the user closes and reopens the form...I've tried [fieldname].requery me.requery, etc etc etc.

What am I doing wrong???

 

[bloody_football]

Same problem

Same problem here - If I open the form I can search through all the data in the table, but if I enter the Form from an 'open form' command in another form it (firstly) won't open the record with the ID number I have supplied from the other form and then (secondly) I cannot choose an ID value from the combo box; again, everything works fine if I open the Form directly.

The code I have used for opening the form are

 DoCmd.OpenForm "FORM - Find Quote", , , "[ID]=" & Me![ID]

and

    'DoCmd.OpenForm "FORM - Find Quote", , , "[ID] like '" & Me![ID] & "'"

but when I look at the Form's property the filter is set at [ID]=53 (or any other number, but whichever number it has still does not come up).
I get the 'No current record' error.

 

[maxmangion]

where did you try the Me.Requery ?

 

[bloody_football]

Tried Me.Requery in several places but it didn't work. Whatever I try to do the properties of the Form are set at "[ID]=73" in the 'filter' field when the form has been opened from another form.

EDIT - I fixed this problem by simply re-making the form, don't know why but it now works