relating forms - example attached

[AJ IT Student]

Hi all.
Please don't think I'm spamming the board!

Rest assured you should be rid of me by tomorrow evening latest!!!

I've created an example of what I need to do.

I need to link the top field (a primary key) to the rest of the form. With a drop down menu, I'd like to be able to select the appropriate ID, and then once selected, have it update the rest of the field with the data relevant to this record.
I hope I'm making myself clear.

This is crucial and is the only thing standing in the way of me having completed my project!!!

Please download teh example and take a look at what I need fixing. If its not too much trouble a working modification of teh example would be ideal.

I have tried to do this on my own already, but have not been able to figure it out

Many thanks.

aj

 

[bradcccs]

You seem to have missed the purpose of this forum.

It is to Help Each Other.

All posts are treated equally. If you were truly thankful for the help you have received, then you would "stick around" to see if you could possibly help someone else.

Not all visitors are experts, and I certainly don't consider myself one, but I have gained my fair share of assistance from the forum, so I try to do my bit.

That said, here you go. One fixed combo box.

Nb: your combo was bound to your PK. An autonumber PK can not be altered. Take particular notice of the coding behind the combo's afterupdate event. This is exactly the process that was hinted to in your last post.

Good luck

Brad.

 

[AJ IT Student]

Brad - that was absolutely perfect.

Thank you very much!

Sick day? unfortunately not!
Next best thing - work from home!

 

[bradcccs]

No problem.

However, we do expect to hear what grade "we" got on your project.

Good Luck

Brad.