Fields populate based on another field

[jlclark4]

I have a form with several different fields.

I have a table with a list of numbers. (Lets say 1-10). Each number has a
corresponding date and type. (tblDailyClaimDate)


I also have a table with the 5 fields listed below. (tblData)

Number (Number)
Date (Date/Time)
Type (Text)
Name (Text)
New (Yes/No)

The form contains the 5 fields above.

I want to be able type in the number and have the date and type auto populate based on the table tblDailyClaimDate and then I fill in the rest of the fields and it write to tblDate.

Is this possible?

I have worked with Combo Boxs populating lists based on another combo box, but not something like this. I am not sure if it works the same way...

Thanks!

[pbaldy]

Is this what you're after?

BaldyWeb - Autofill

[jlclark4]

Does this still work if the Number field is just a text box not a combo box? There doesn't always have to have information populate in the Date and Type field...

They also wouldnt be selected the number from a list, they would type in the number.

[pbaldy]

No, that method uses the columns of the combo box. You can still use a combo, as the user can type in a number as well as select one.

If you want to use a textbox, you'd have to use DLookup or open a recordset on the table to get the related values. Since you want more than one value, the recordset would be more efficient.