Use Toggle button to select subform value

[DerekAwesome]

I need to have a toggle button on the left of a subform that can select a value in the subform so I can use put it into a textbox in the parent form or something like that. Max values in subform right now is only 2.




Any suggestions?

EDIT there is only one field in the subform, if that makes it easier

[June7]

Not really. Why would a value need to be taken from subform and placed on main form? What are you really trying to accomplish?

[DerekAwesome]

hahahhaha I'm trying to accomplish getting the points because this is all credit no credit, my professor is a dumbass, and it's due in 45 minutes.

he explicitly stated there needs to be toggle buttons to the left of the subform (which I never thought was possible or applicable) that need to be used to select an account to make a deposit into. Subform has accounts of students selected in a list box above


sorry for being a little agressive. Just stressed

[June7]

45 minutes!? So many unknowns, doubt will meet the deadline. Nothing like waiting till the last minute.

I agree, a toggle button doesn't make sense.

The main form is bound to students and subform is bound to accounts (these are students accounts and students have multiple accounts?)? Never seen a toggle button used like this. Is this a toggle button next to each record in the subform that is bound to a Yes/No field of accounts table or is this a toggle button that actually sits on the main form? If the button is on main form and subform is in datasheet view, have to first select record in subform then trigger event that would save the account number to textbox on main form. It might even be code is not needed. The main form textbox ControlSource could have an expression that references field of subform.

If you want to provide db for analysis, follow instructions at bottom of my post. Be aware if it is an Access 2010 file with Access 2010 exclusive features, might not be able to open it until late tonight.

What do you mean by 'max values in subform right now is only 2'?

[DerekAwesome]

Maximum accounts that any of the students have is 2. But don't worry about it now. It was actually the final for this class, but we are allowed to use the internet because I thought I'd try. Most people get zeros on the final anyway

[June7]

Oh, you are in class and just given the problem as an exam! If single toggle button on main form then code in Click event could be like:

Private Sub ToggleName_Click()
If Me.ToggleName = True Then
    Me.TextboxName = Me.SubFormName!FieldName
Else
    Me.TextboxName = Null
End If
End Sub

Again, must select record in subform before clicking toggle.

Good luck!

[DerekAwesome]

Sorry for the late response, I didn't get to implement it for the points that time but its exactly what I needed and I'll remember it for next time. Thanks!

now if I knew how to mark as solved I would

[June7]

See the Thread Tools dropdown at top of first post.