Forms, Drop Down Lists tables etc...

[Goldfish]

Hello all!

Ok, I have issues - my memory being the worst issue of all.

I have used Access in the past, but not for a good few years and in that time I have managed to forget pretty much everything I used to know :banghead:

Anyway, my problem (and I apologise as I'm sure this has been covered before by someone else in another post - but I'm lazy):

Table: Module [Module_ID, ModuleName, Application_ID, etc etc]
Table: Application [Application_ID, AppName, etc]

I have a form which I want to use to enter a new Record into a table called 'Module'.

The table 'Module' has an ID reference to another Table 'Application'.

What I want the user to be able to do in the Form is to select the Application they wish for the new Module via a Drop Down List, but show them the Text (AppName) of the Application and not the ID number.

[Edit:] So, to summarise, I want the user to see the Text, but the new record needs to store the Application_ID number, due to the table references...[/Edit]

For the love of god I cannot work out how I do this, or what exactly to search for in Google!

If you know of any existing "How-To's" then that'll do - anything to kick start the old brain into gear

Thanks for any and all replies

 

[CJ_London]

First off, if you have names your tables 'Application' and 'module' you will have problems because these are reserved words.

FYI here is a link to Access reserved words

http://support.microsoft.com/kb/286335

To answer your question, you need to use a combobox.

For the properties for your combobox set the following (change names to suit):
Recordsource: SELECT AppID, AppName From tblApplications ORDER By AppName
datatab>controlsource: Application_ID
datatab>Bound Column: 1
datatab>Limit to list: yes
formattab>Column Count: 2
formattab>Column Widths: 0cm,2cm

 

[Goldfish]

Aha, yes thanks!

Names of tables have prefixes, so it hasn't caused a problem, I was just being lazy whilst typing!!

thanks for the reply!