Populating fields

[Jrw76]

I have a table called Label Sizes. The fields are ID, Name, Size, Font.



I have another table called Label Plate Data. In that table, the three fields listed above are all drop combo boxes in this one. What I want to do is, when the user is enters in the Name, I want Size and Font to populate automatically. What do I need to do?

[pbaldy]

In a form you can do this:

BaldyWeb - Autofill

Don't think it's possible directly in a table, but I never let users see tables anyway.

[rpeare]

in your combo box put all four fields, make your column widths 0, 1, 0,0

put two unbound controls (assuming the combo box shows the name already)

let's assume for the sake of this example your combo box is named cbo_Test

in the first unbound control put:

=cbo_test.column(2)

in the second put

=cbo_test.column(3)

[Jrw76]

in your combo box put all four fields, make your column widths 0, 1, 0,0
Not sure where you mean. This is a drop down menu because it is using the information from tblLabelSizes.

put two unbound controls (assuming the combo box shows the name already)

let's assume for the sake of this example your combo box is named cbo_Test
The name is Size Code so... cbo_Size Code?
in the first unbound control put:

=cbo_test.column(2)
Put this where?
in the second put

=cbo_test.column(3)

Put this where?

[ItsMe]

You are using a lookup field in your table? I advise against doing this. To answer your question, if it is a lookup field you are referring to, the stored value will be the Primary Key to the other columns you defined in your lookup field. The ID represents Name, Size, Font. If you chose to store ID and display Name.

Storing the ID virtually sores all four fields in a single lookup field.

[ssanfu]

Also, NAME and SIZE are reserved words in Access and shouldn't be used as object names.
http://allenbrowne.com/AppIssueBadWord.html

[Jrw76]

in your combo box put all four fields, make your column widths 0, 1, 0,0

put two unbound controls (assuming the combo box shows the name already)

let's assume for the sake of this example your combo box is named cbo_Test

in the first unbound control put:

=cbo_test.column(2)

in the second put

=cbo_test.column(3)

Ok, This works!!!! THANK YOU!!!