Getting data from a subform and using it in the main form

[xpun]

hey everyone

I was wondering if it was possible to get data form a subform and use it in a conditional in the main form

this is what I’ve got so far bu it doesn’t really do anything

If Forms!Transactions.Query1subform.Form!feild.Billingcode = 1 Then ...

any help would be greatly appreciated.

[JConsulting]

hey everyone

I was wondering if it was possible to get data form a subform and use it in a conditional in the main form

this is what I’ve got so far bu it doesn’t really do anything

If Forms!Transactions.Query1subform.Form!feild.Billingcode = 1 Then ...

any help would be greatly appreciated.

That creates a circular condition don't you think?

What then happens to the records in the subform?

It can be done...but just because it can, doesn't mean it should.

Do you have some kind of button or event you wish to use to kick the code off?

if you're running this from the main form

if me.mysubform.form.billingcode = 1 then
me.filter = "somefield=somevalue"
me.filteron = true
end if
 

J

[xpun]

That creates a circular condition don't you think?

What then happens to the records in the subform?

It can be done...but just because it can, doesn't mean it should.

Do you have some kind of button or event you wish to use to kick the code off?

if you're running this from the main form

if me.mysubform.form.billingcode = 1 then
me.filter = "somefield=somevalue"
me.filteron = true
end if
 

J

yes this bit of code would only run once when a member has 8 transactions. the idea was to make it part of a print routine , if a members billing code is one print one report if its 2 print the other