Populating Fields

[RuralGuy]

Can you post your db? Remove or scramble any sensitive data of course.

[deiniolj]

Here you go, The form i am trying to put on the Main form (frmdetails) is frmfbnames, as you can see at the moment the fields are manually inputted..

Thx for your help

[RuralGuy]

I'm not sure how you want your form to function! SubForms are usually for displaying the many side of a 1:m relationship and so the SubFormControl has LinkChild/MasterFields properties to keep the SubForm in sync. Your SubFormControl has these properties set to RecordID so I doubt you will ever get the results for which you are looking.

[deiniolj]

Thx for taking a look, I thought it wouldn't work. On another note, what is the best way to go around getting a automatic email to go out when a field is changed in a combo box. If you look at the field status in my datatbase.(if you still have it) what I need is for it to send out email when the field is changed. ie "sent to lea" would send an email to accounts saying it ready for invoicing.

[RuralGuy]

With what part of emailing are you have difficulty?

[deiniolj]

I would like it to send out different email at different points, i.e send to LEA goes to accounts, Complete Installation end user get notified his equipment is ready.

[RuralGuy]

This may be the link for which you have been searching.