CODEWITHSUNDEEP
databaseformsms-accesscomboboxms-access-2016
Darokrithia
Darokrithia

Reputation: 160

Access will not let me add a specific field into a combobox (although it allows other fields that I do not want)

I am very new to access, so I assume that I am just doing something terribly simple wrong, but I am totally lost. I am making a form to sort data for a hospital that I am interning at, and while everything so far has been a breeze, when trying to make a combobox in a data entry form, I am unable to add the data I want into combobox (Procedure and Physician), although I can add the ID for whatever reason. I have posted screen shots of my query and of what happens when I try to add in the combobox, and I am more than willing to add additional information if need be.

Also, don't worry, I checked with my supervisor and she said that posting this online did not break HIPPA or any other legal rules as there is no patient information in the database (yet).

Query for physician comboboxes

Query for procedure combobox

I select the correct query

All items besides the ID are missing

The same thing also happened in both of my physician comboboxes.

Upvotes: 0

Views: 49

Answers (1)

JJ32
JJ32

Reputation: 1034

Is the ProcedureName field a Memo field? If so try changing the query to select it using CStr:

SELECT CStr(Procedures.ProcedureName) AS ProcedureName

Check if there are any Memo fields in your Physician table as well and try a similar approach.

Upvotes: 1

Related Questions