Combo Box Control - How to Show Fields on Form

[wevodaur]

HI,



I have made a simple database for my family medical records, and I am having some trouble making a form do what I want. I have, among others, a Table for Office Visits and a Table for Medicare details (allowed, paid, etc). The Office visits table has information on Date, Patient and Doctor, and VisitID as primary key. I have the VisitID in the Medicare table also in order to join it to the Office Visits table. I made a form to input the Medicare data (used the form wizard). I then added a Combo Box, linked to a query from the Office Visits table to present the user with Date, Patient, and Doctor and VisitID, and then storing the VisitID for the selected record in the Medicare table. I cannot figure out a way to have the fields from the Office Visits table (other than the VisitID) stay on the Medicare input form (the VisitID does get placed in the Medicare table). Having the VisitID on the form alone (without the other three fields from the Office Visits table) is confusing to the user. I guess my question is "How do I make all the fields that show up in the Combo Box for a given record stay on the Medicare input form, not just the one (VisitID) that is actually on the Medicare form"?

I'm one - maybe two - baby steps above beginner, and I think I might be missing something obvious. Also, it's hard to describe my problem. So, if anyone has had a similar problem or knows how do to what I am attempting I would appreciate any help.

I will attempt to add a picture, but this is my first post and I'm not at all confident this will work!



Thanks,
Robert

[ssanfu]

Try watching LearnAccessByCrystal (about combo boxes)