Subform to Parent form data retrievle

G

Guest

Hi out there,

I have a data base i am build for my scout troop. There is a Scout Account
(kind of a savings accout for each boy) and i have a query "Avaliable" which
summerizes all records in the Scout Accout table by ID (the key).

Any way, here is the issue. There is a Scout accout entry form, SAAddrecs
with a linked sub form SAAvailale which searches for the current available
balance.

The main form has a list box (control SAID), a SAreason control a list box
for reason for withdrawal, and SAAmount (which needs to be verified).

After entering a vailid ID the subform retrieves the available balance,
that works just fine.

Next i need to check the SAAmount against the boys available balance to
avoid over withdrawal.

I can't seem to get the data from the subform to the parent form as a vaild
field.

How can i define a public (global) variable which will contain the available
balance to pass to VBA.

Dick
 
G

Guest

Greetings!
If I understand your question, you want to know how to read a value from a
subform in your main form vba code.

The syntax would be: forms!MainFormName!SubFormName.form!SubformControl
HTH
Sam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select records with form driven input 2
How force table update when no bound field updated? 1
Save parent form after transaction update 6
Single parent form contains multiple instances of the same subform 8
Refresh main form control when subform exited ? 3
ApplyFilter gives error only when subform is placed on main form 1
Copying data from parent form to subform 8
incorrect report from parent/child subform. 2

Top