Combo Box Question

[Minuet]

Is it possible to have a combo box that pulls up information from a record, but instead of pulling up information for each field in the form, it leaves certain fields (which I have specified) blank?

 

[Orion45]

In the properties of your combo box click on the record source field and click on the elipsis(...) on the far right. This will allow you to make a query based on your table where you can specify the criteria you need. Hope this helps.

 

[Minuet]

I work in a hospital and have a database which contains patient information. I pull up information on particular patients by typing in their unique chart number into a combo box. I would like to create a second form exactly like my main form. When I type in a chart number in my second form, I want it to take the patient information from the main form and display it in the second form, but I want it to look up only certain fields, and leave other fields (like a date field) blank. For complicated reasons, I need to enter near-duplicate records, and instead of typing in all patient information every time I make a new record, I want Access to automatically fill in most of the fields to save time. (I hope this makes sense.) Is this possible?