Active row in continuous form.

[Clayhead]

Hi. Im still pretty new to this and looking for someone to help me with some code.

I have a form called "Interface" on that form there are tabs which display different forms.

On the Tab "Accounts" i have a continuous form with multiple records.

What i am trying to do is.

- Have a text box on the "Interface form at the top.
- Have this text box display the field name "account ID" of the active (highlighted) record that has been clicked on on the Continuous form on the accounts tab.

I have been at this for days now with no luck. Please help.

 

[Minty]

I'm assuming the continuous form is a subform on the tab?

if so lets call your text box on your Interface form txtAccountNo - in the OnCurrent event of your sub form you would use something like

Me.Parent.txtAccountNo = me.AccountID

If that doesn't work post up the code you have tried and the exact names of you controls. (Not the field names - the control names)

 

[Clayhead]

Works a charm. Thanks for your help