I realise this has been answered, but I didn't undrestand the answer!
I have to program a database at work which must include lots of fields that have a code number and a name, for example, Ship Number and Ship Name.
I have a Main table containing all required fields on the form and a second table containing all possible ship names and numbers.
On the form, I have a combo box based on the Ships Table. It displays both columns, so the person entering the data can click the drop-down box and select the code if they know the ship name. I need the ship name to then enter automatically in an adjacent text box. Assuming the form is called Ships, how do I do this?
On a database programmed by someone else, they use a subform, but I've never had to use subforms, and it doesn't seem to work when I try importing it and substituting names.
Can I achieve this auto-fill without a subform?
Do I need to create a query for the Ship Name text box?
Please answer in a step-by step way, because although I work as a I.T. guy, I have learned Access without any documentation and don't understand some of the terms used!
I have to program a database at work which must include lots of fields that have a code number and a name, for example, Ship Number and Ship Name.
I have a Main table containing all required fields on the form and a second table containing all possible ship names and numbers.
On the form, I have a combo box based on the Ships Table. It displays both columns, so the person entering the data can click the drop-down box and select the code if they know the ship name. I need the ship name to then enter automatically in an adjacent text box. Assuming the form is called Ships, how do I do this?
On a database programmed by someone else, they use a subform, but I've never had to use subforms, and it doesn't seem to work when I try importing it and substituting names.
Can I achieve this auto-fill without a subform?
Do I need to create a query for the Ship Name text box?
Please answer in a step-by step way, because although I work as a I.T. guy, I have learned Access without any documentation and don't understand some of the terms used!