How to view record from another table in unbound text box in a form

[saledo2000]

Hi Everyone,
I am a beginner in access but trying hard and learning every day. Could you please help with my problem to view record from another table in unbound txt box on a form. I have two tables Reg and Gender. My table Gender has two columns where one is Gender (e.g. Male) and second column with gender symbol (e.g. for Male is M). On my first form Regfrm I select Gender from a drop down list and that is ok. I have created a Form RegDatafrm where my record source is set to table Reg. I want to see gender symbol for each student on a form using unbound box. I have tried Lookup property but do not get anything in unbound txtbox. Can you help on this please, would appreciate very much.
Thank you in advance.

 

[theDBguy]

Hi. If you're saying you tried to use DLookup(), then please post what you tried, so we can help you fix it.

 

[isladogs]

please help with my problem to view record from another table in unbound txt box on a form.

There is no need to use DLookup

Change it to a bound combobox with the combo control source = Gender field in the Reg table and the row source set to the values in the Gender table (or a value list)
This will allow you to select M or F and then save that for future use

 

[pbaldy]

Here's a reference to let you fix it yourself:

http://theaccessweb.com/general/gen0018.htm

 

[CJ_London]

according to Facebook there are now 71 genders

https://www.telegraph.co.uk/technol...books-71-gender-options-come-to-UK-users.html

 

[saledo2000]

Hi. If you're saying you tried to use DLookup(), then please post what you tried, so we can help you fix it.

I have to use combo box in DLookUp but I need just to edit record (Gender symbol) on a form from Gender table.

Hope this answer will find all others who replied to my thread. Thank you

 

[theDBguy]

I have to use combo box in DLookUp but I need just to edit record (Gender symbol) on a form from Gender table.

Hope this answer will find all others who replied to my thread. Thank you

Hi. Not sure I understand. You might consider posting some images to help others follow what you did, just in case. Good luck with your project.

 

[isladogs]

Which table contains the Gender field for each student?

 

[saledo2000]

Which table contains the Gender field for each student?

Table Reg has Gender field where is record e.g. Male. In Gender table in the second column is symbol for Male is M.

 

[theDBguy]

Table Reg has Gender field where is record e.g. Male. In Gender table in the second column is symbol for Male is M.

Sounds like you may be talking about a lookup field. Are you?

 

[saledo2000]

Sounds like you may be talking about a lookup field. Are you?

Yes but need to display only a symbol for gender on the form RegDtafrm in a textbox

 

[theDBguy]

Yes but need to display only a symbol for gender on the form RegDtafrm in a textbox

Hi. Did you read the link I posted above? Just curious...

 

[isladogs]

Saledo
Please read my comments in post #3.
There shouldn't be a lookup at table level. Nor a DLookup expression.
Just use a bound combo as I suggested

 

[saledo2000]

Hi. Did you read the link I posted above? Just curious...

Yes I read you link. Thank you. I want some other solution if is possible not to use Lookup option. If you have something in your mind will appreciate.

 

[theDBguy]

Yes I read you link. Thank you. I want some other solution if is possible not to use Lookup option. If you have something in your mind will appreciate.

I would suggest reading Colin's suggestion above. Let us know if it's not clear to you.