option buttons connected to other stuff

[obertseph]

I made a form in Access and am trying to set it up so that in one section you can choose from a list of past contacts, and if the contact isnt on that list, then you can enter in the name and adress of the new contact. So i made an option button group to select if the contact is on the list or if you are entering a new one, a drop down box that contains the past contacts, and some other text boxes so you can enter the new contact, but i have no idea how to make them all work together. Any help would be greatly appreciated

[pgag45]

Option buttons must be placed in a frame for them to work together...

to tell which one the user has chosen is basically going to be a bunch of conditionals...

if OptionButton1.checked = true then
do something
elseif OptionButton2.checked = true then

[obertseph]

ok, but what VB code would i write so that my form uses the information in the drop down box over the information in the new contact text boxes, and vice versa

[pgag45]

Not quite sure what you are trying to accomplish... Could you try explaining how these are all related again?

[obertseph]

I have a form for people to enter new data into a database. Each new data entry contains a contact. I want to make it so they can choose a contact from a list of past contacts, or enter new information if their contact isnt in the database already. So i have it set up that there is an option button where you can choose to either pick a contact from the ones already in the database, via a dropdown box, and the other option button in my option group would be connected to an area where they can enter new contact information. Or at least thats what i hope to achieve. If you have any idea how to go about doing this, or an easier way i would greatly appreciate it.

[pgag45]

Option button could work, but I think it might be easier to just have two command buttons. One button next to the dropdown box, saying "Select contact from dropdown" and one button next to the text box, saying "Select custom contact" or something like that ...

But if you want to stick to your option button here's some pseudocode...

if optDropDown.selected = True Then
   'check to make sure an item in list is selected
   'assign that value
else 'they are entering new information
    'make sure valid entry
    'assign that value

hope this helps

[obertseph]

i'm really lost when it comes to using visual basic. How can i make it so that it will take the values from my drop down list, and put them in my table as an entry.

[Ecniv]

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

select case fraChoice
 case 1
   '---- use old details from list
 case 2
   '---- code to use the new details
end select

[obertseph]

ok, but what is the code to tell it to use those details from the list, thats what I cant figure out, my MS Access book doesnt talk about code that can do that.

[pgag45]

http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx

[obertseph]

nevermind, i am just going to use an alternative technique