In Access on an Access Form:
Create a frame control
Rename the fram control to 'frmChoice'
Drag n drop in two option buttons
Change the text of the option buttons
Set the frames default value to 1
Code:select case fraChoice case 1 '---- use old details from list case 2 '---- code to use the new details end select




Reply With Quote