Take Data from Table or Query

[notrino]

Dear All,

I attached my application. When I entered a data on deneme-1 table part of bilgi1, I want to call this data on deneme-2 form part of bilgi2. Normally, I can do it with standart access query but I want to do with VBA code. How can I do it? Thank you.

[NTC]

Sorry I do not look at attachments. In general what you describe is a Look Up field type. When you select this option in the table's field property - the wizard will guide you to which table you wish to look up.

The alternative for this is at the form level - to use a combobox field type and option its record source to be the table you want.