Linked Form Fields - How?

[0bsidian]

Hi,

Firstly, I'm quite new to anything beyond a relatively simple database, so please bear with me if I am being a little slow on the uptake.

I have a form which has been produced directly from a table (tbl_pupiltrans) as a means of input. However I want some of the fields on the form to react to each other when data is inputted.

For example, when the Pupil Name is entered I would like the pupil ID to autofill with the ID listed in the lookup table (tlkp_pupil) (note at the moment you select a pupil name from a combo box list, but that could be changed if not appropriate). Likewise, I'd like the Price field to populate when the Product Description is inputted (also a combo box) etc etc.

Can someone explain how I accomplish this - your help is greatly appreciated as this is causing me some frustration.

Many thanks,

0bs

 

[0bsidian]

Hmm...

Have I underestimated the complexity of what I want to do, or have I explained it in a really stupid way which makes it difficult to see what I am getting at?

If it's the latter, feel free to tell me and I'll try to clarify.

 

[0bsidian]

Thank you very much Pat! That's solved my problem - I just have to figure out how to hide those text fields on the form - but I imagine I'll some code for that

0bs