var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Making data from the form appear in the table.
Please find the form attached.
When entering the information into the form, i want the surname from the form to automatically appear in the table below the form?
I am really unsure how to do this? is it something that i would need to change with the relationships?
Some help would be greatly apprecitaed.
Your subform needs to have a query assigned to it which selects values based on the surname typed in. Something like...
You also need an event procedure after you update the SURNAME so using the ON UPDATE event
WHERE Surname = [Forms]![FormName]![FormItemName]
Private Sub SURNAME_AfterUpdate()