Form Design Toggle buttons

  • Thread starter Thread starter KarenMike
  • Start date Start date
K

KarenMike

I have created a couple of toggle buttons "use member address" and "use
Alternate address".

If I have member address checked, I want to fill in with information form
the "member table". If alternate address checked, I want to manually enter in
fields provided.

Any suggestions?
 
Karen,

Are these option buttons inside a frame (option group)? If so, only one of
them will be able to be toggled at a time, and you can identify which one
based on the value of the frame. So, you could do something like:

Private Sub og_UseAddress_afterUpdate

me.txt_Address1 = IIF(me.og_UseAddress = 1, "Member", "Alternate")

'actually it is more likely that you need something like:
if me.og_UseAddress = 1 Then 'MemberAddress
me.txt_Address1 = DLOOKUP("Address1", "tbl_Members", "ID = " &
me.txtID)
else
me.txt_Address1 = ""
endif

END SUB

HTH
Dale
 
Back
Top