Use table info in a textbox

[hendrikbez]

I need help please

I have a access 2010 file, with 3 tables.
On my form I have a tape Textbox where I put tape numbers in that is on a other table inside my access file (for now I just type a tape number in), then save the info to other table also inside access file.
I want to know how can I make it that if I put a tape number in the textbox, it must look at the table for tapes, and if the tape number is not in the tape table, it must not let me use the wrong tape number that is not in the table for tapes.

 

[Galaxiom]

Use a combobox. This can be set up so you can only select existing tape numbers.

 

[hendrikbez]

Use a combobox. This can be set up so you can only select existing tape numbers.

I did try a dropdown list, but could not get it to work, If I use it, and choose a tape, it shows on my form even if I move next or endof, the same tape number is there

 

[Galaxiom]

You need to bind the combo to the RecordSource of the form.

Type the name of the RecordSource field into the combo in design mode.

 

[hendrikbez]

You need to bind the combo to the RecordSource of the form.

Type the name of the RecordSource field into the combo in design mode.

Thanks, but I am new to this, so I do not understand what you are trying to say to me