Hi,

I have a table
Table 1: Surname, Initial, Work Number(no duplicates), various address details.
And I want to create a new datasheet that has an autonumber followed by a combobox which contains Surname, Initial and Work number.

or a new datasheet which you can select the surname and the other fields fill themselves in from your selection.

I cannot work this out.

Thanks in advance.

I think I can get you started.

Add an Autonumber field to the table design.
Use the Wizard to make a form based on the table.
Don't think you want a datasheet. This shows all records in a form that looks like a table. I think you are wanting a single form.

Add an unbound combobox to the form based on the surname field.
Right click on the combo and turn on Properties.
Event tab. After Update.

You probably want the macro builder.
I don't do macros 'cause I prefer VBA.
(But nobody else has answered.)

Click the ... button
See if you can build a macro to find a record using the combo as input.

Sorry for only half answering. Hopefully somebody will do the rest for you.