Lookup table

[SHAWTY721]

I am creating a database and I need to create I guess in a way a lookup/mapping table that will automatically load onto a form based on the initial selection in a drop down menu. Is there any easy way to create this type of table.

 

[acent]

I don't know about the other gurus here, but I'm lost as to what you want. I'm assuming this is not the recordsource of the form.... What is the table mapping?

To simply load a form and have it be accessable, you could use the onload event and create a recordset...

"If it's stupid but works, it isn't stupid."
-Murphy's Military Laws

 

[PHV]

Bottom line; WHAT DO YOU WANT TO DO ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya SHAWTY721 . . .

Just a 1st shot at this.
[ol][li]You open with no [blue]RwecordSource[/blue][/li]
[li]User selects from combo and [blue]RoecordSource[/blue] is set accordingly! (can be done!) . . .[/li][/ol]

[blue]Your Thoughts! . . .[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884: