Viewing Name and not stored ID

R

Ripper

I have a form that opens up a record and views all the fields, selected via drop menus, from another form

To save space, I don't store the actual responses, but rather the id number from the tables where the possible responses are stored

I have 1 field, Reason, on the form, frmDiscipline. This field is from a table, tblReasons. The stored number is kept. How do I display the actual reason on the form frmDiscipline

I don't know if this would make sense to anyone but me, but I will claify if necessary

Thanks As Always
RIP
 
A

Albert D. Kallal

Well, you can use the combo box wizard to do this.

It will stroe the id,but actually display the text from that other table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update from a Combo box 1
Name saving as ID 6
Linking two Subforms & showing name in place of ID? 1
Form is filtering out values 2
Table - missing data 6
How to display OLE Object (e.g. Word Doc) on form 1
Custom Fields for End User? 7
filling a control in a continuous form with a field from a table 2

Top