Automatically filled fields

[geoffishere]

I have a form with a combo box. When you select an item out of the combo box it automatically shows you information about that record.

The field in the the combo box is called completemodnumber and is a primary key in a number of my tables. in on of the tables in which completemodnumber is not a primary key it is matched with a few fields called crn. Therefore i am in a situation where for every completenumber there are one or two crn.

At the moment when i selct completemodnumber it only shows one of these crn, is there any way of getting it to show all the crn.

Hope this makes sense

many thanks

Geoff

 

[vbaInet]

Haven't really understood your requirement Geoff. Please elaborate. It's quite odd showing Primary Keys anyway.

 

[geoffishere]

i have a combo box with titles in, when i select a title, information is shown about it. One of these filelds (CRN) could have more than one instance connected to the title.

At the moment when i select the title it only shows one of these CRN, is there a way to show all of the CRN's

 

[vbaInet]

It's still quite fuzzy. Can you post your db?

 

[geoffishere]

Ok i have had to deletemost of it as it wouldnt let me upload it.

If you go into form Module CRS

select mel walker in first combo box then gender and health in second combo box

In the CRN it now shows 15316, however if you look in the table instances there is also a crn 15312 also connected with B90030019 which is the primary key.

Is there a way of showing both CRNs

Beware the warnings as i have delted some table to get it small enough, and also the form is still in devlopment thats way its a it messy

 

[vbaInet]

When you delete, you should COMPACT & REPAIR to get rid of the bloat.

Wait to see the file name appear on that window after you click Upload before closing the window.

 

[geoffishere]

sorry forgot the file hopefully this will work

 

[vbaInet]

Still no luck Geoff. Did you zip your db?

 

[geoffishere]

try again, hopefully this will work

 

[vbaInet]

You have a query that filters results based on what is entered on the form.

1. Create another query that does the same but for just to show CRNs. You would need to include both tables in the query.
2. Use a list box, not a text box and set its row source to that query.
(You can use a text box but that means you would need to program it so just use a list box.

Looking at your relationships I think your db could do with some normalization. Do a google search on that term