AUID Number showing instead of text (1 Viewer)

HowardHelp

New member
Local time
Today, 01:51
Joined
Feb 1, 2021
Messages
26
I have a table when viewed you can see the values in text form, when referenced in a form text appears as a number, which I don’t want.

The field gets its information from another table (table1a) in the main table lookup properties is the reference to the second table (table1a) in the design under Row Source and it looks like this

SELECT DISTINCTROW table1a.AUID, table1a.fldMusicType FROM table1a;

The table1a is a separate table which can be seen in the relationships in a queries because of the above code.

I quite simply want to know how if possible to view this as text in a field in my form without modifying the main table but I can modify the table1a or my queries or my form of cause.

I understand the number I see in my form is the tables AUID reference to the text I require in the table table1a.

Anyone have any simple suggestions, much appreciated.
 

Attachments

  • table1a.jpg
    table1a.jpg
    79 KB · Views: 99
  • form.jpg
    form.jpg
    20 KB · Views: 104

Ranman256

Well-known member
Local time
Yesterday, 21:51
Joined
Apr 9, 2015
Messages
4,339
in table design, look at the field's DEFAULT VALUE,... its prob set to that value. remove it.
if not, then there's some code putting it there.
 

Pat Hartman

Super Moderator
Staff member
Local time
Yesterday, 21:51
Joined
Feb 19, 2002
Messages
42,981
Remove the table level lookup. They are a crutch and nothing but trouble as you can see.

you NEVER need to see the text in a query because users don't see queries. On a form, you would use a combo. The combo is bound to the ID and has a RowSource that selects the items from the table that defines the ID. The wizard can build this for you.

Also, always set the default for foreign keys to null. Do not leave the Access default of 0.
 

HowardHelp

New member
Local time
Today, 01:51
Joined
Feb 1, 2021
Messages
26
Remove the table level lookup. They are a crutch and nothing but trouble as you can see.

you NEVER need to see the text in a query because users don't see queries. On a form, you would use a combo. The combo is bound to the ID and has a RowSource that selects the items from the table that defines the ID. The wizard can build this for you.

Also, always set the default for foreign keys to null. Do not leave the Access default of 0.
Hi i tried setting the 0 to null on the main table, do you mean use the combo on the form, if so the problem with that is the main table is from another database, the values you see is read only in the form so i want it to reflect the table, thanks through
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 09:51
Joined
May 7, 2009
Messages
19,169
Yes the link sounds very much like the problem
yes, to those who are novice.
but if you aged in access, and know what you are doing, it is an Angel.
 

Users who are viewing this thread

Top Bottom