Access 2000 - Drop box

[Guest_imported]

I'm tryig to update a list box on the same form as a drop box - I want to use the drop box to select the record source for the list box...
this is driving me quietly insane - i've RTFM, technet etc,
and no joy

Anyone got any idears ?

 

[DougP]

You need to refresh the recordsource of the form
by using a book mark
look at this snippet:
-------------------
Dim SyncCriteria As String
Dim f As Form, rs As Recordset

'Define the from object and recordset object for the AutoCAD form
Set f = Forms(Screen.ActiveForm.FormName)
Set rs = f.RecordsetClone

' define the criteria used for the sync
SyncCriteria = "[YourField]='" & Me![YourField] & "'"

' find the corresponding record in the Parts table
rs.FindFirst SyncCriteria
f.Bookmark = rs.Bookmark
--------------------- DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive