How to use a different Table or Query in Current Form????

[tqd123]

If I create a from using a certain Table or Query for the form's "Record Source". When I am in an Event in that from, how I specify to use a different Table or Query to get some other data???

Thanks,

TD

 

[fneily]

You could put some code using the Dlookup function on the OnCurrent Event of the form like this:

Private Sub Form_Current()
Me![ControlOnForm] = DLookup("[TableFieldName]", "TableName", "[PrimaryKey] = " & Chr(34) & Forms![FormName]![PrimaryKeyOnForm] & Chr(34))
Me![ControlOnForm] = DLookup("[TableFieldName]", "TableName", "[PrimaryKey] = " & Forms![FormName]![PrimaryKeyOnForm]
End Sub

I gave one example for matching a string, the other to match a numeric.