I would like to have a form that will update tables dependant upon which field has data. For instance if a person were to enter in an organization name, I would want the organization table to be updated...if a person entered in the Client Name, I would want the client table to be updated. Both tables have same fields associated with them...such as address, phone, fax etc. Is it possible to do this on one form or should I save headache and hassle by simply using a tab control? Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
One form 2 tables or a tab control? 1
- Thread starter SeeWard
- Start date
-
1
- #2
- Thread starter
- #3
Hi!
Thanks for responding! No, there is no logical link between the two tables...totally seperate info. I was thinking that I could have the tab control to split the info up. But then again since the only fields that are essentially different are the organization name and the client name I thought maybe I could figure out code that would populate the fields in the proper tables if one of those fields were selected. If a user typed in a client name then the client table would get the info...if they filled in the organization name then the organization table would get the info....
Thanks for responding! No, there is no logical link between the two tables...totally seperate info. I was thinking that I could have the tab control to split the info up. But then again since the only fields that are essentially different are the organization name and the client name I thought maybe I could figure out code that would populate the fields in the proper tables if one of those fields were selected. If a user typed in a client name then the client table would get the info...if they filled in the organization name then the organization table would get the info....
Well, if you really want to do it with one form then I would recommend a frame with two radio buttons and have the user click which type of information they are entering client or organization. Then all you need to check in the code is the value of the frame.
hth
Jeff Bridgham
Purdue University
Graduate School
Data Analyst
hth
Jeff Bridgham
Purdue University
Graduate School
Data Analyst
- Thread starter
- #5
Hi!
A frame is also known as an option group. In the toolbox it looks like a rectangle with xyz on the top. You can put it on the form and then the wizard will lead you through setting it up.
hth
Jeff Bridgham
Purdue University
Graduate School
Data Analyst
A frame is also known as an option group. In the toolbox it looks like a rectangle with xyz on the top. You can put it on the form and then the wizard will lead you through setting it up.
hth
Jeff Bridgham
Purdue University
Graduate School
Data Analyst
- Thread starter
- #7
- Status
Similar threads
- Locked
- Question
- Locked
- Question