Allow Combo to read from 2 tables

1eye1vision

Registered User.
Local time
Today, 18:37
Joined
Aug 27, 2005
Messages
33
Ok, what i have is a form on which a user has an Option Group for selection on which records are shown (consumable and Non-consumable), also on the form is a combo box which reads from Table Asset Categories. However what i want to do is allow this combo box to read from another table depending on which option is selected in the Option Group. ie change its Table and row source, but i can't figure this out. I thought something in the region of:

If Me.OptionGroup = 0 then recordsource = "Asset Categories"
Else RecordSource = "Consumable Categories"
End IF

Any Help Please
 
What a Star

Asentry,
Well what can i say what a star, the Combo Box example was exactly what i was looking for, i have now implimented this into my DB and all is working well.
Many Thanks for the help.

Regards
1E1V
 

Users who are viewing this thread

Back
Top Bottom