473,320 Members | 1,965 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

CBObox with more columns wih value over to bounded txtbox

I have two tables (called TBUser and TBGroup)Whose values CBO retrieves data from. CBO has multiple columns of information that I want it to be stored in their respective fields (TXTUser and TXTGroup). Txtboxes are bounded to TBCASE. Name of the form is FRMCase. How to solve this?
Dec 6 '16 #1
5 885
Extra info :
Because I can not use =[CBO102].[column](2)and save value in table at the same time. Or can i use =[Kombinasjonsboks102].[column](3) and insert to TBCase.Group (Is this possible?).
Dec 6 '16 #2
PhilOfWalton
1,430 Expert 1GB
It sounds to me as if your database is not normalised, and whilst it is possible to do what you want, I guess it would be a bad idea.

What is the structure of your 3 tables and what is their relationship?

Phil
Dec 6 '16 #3
Maby i should say it like this. what is the vba code for taking the value from a txtbox to a form. and put it in eg column2.
Dec 7 '16 #4
But you asked about relationship, TBCase have a field named name. Are linked to TBUser with the field name. And TBUser have a field named Group linked up to TBGroup
Dec 7 '16 #5
PhilOfWalton
1,430 Expert 1GB
Firstly, with relationships. May I suggest that your Group Table should have a field GroupID AutoNumber Primary Key.
Your User Table a field UserID AutoNumber Primary Key and a Foreign Key of GroupID.
Your Case Table a field CaseID AutoNumber Primary Key and a Foreign Key of UserID.
Using text fields as links is not a good idea as if the field gets changed, data might become lost. UserID = 1 can't change, but if the first user (as text) changes their name from Smith to Jones, confusion arises.

Now back to the original question. The data in the different columns of a combo box comes from the underlying query, so the query obviously must contain the data in the text box that you are interested in.

So in principal, enter the data in your text box (I'm assuming that it is bound), save your record and then requery your combo box.

Phil
Dec 7 '16 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Marc Floessel | last post by:
Considering the following example table: Column1 | Column2 | Column3 =========================== NULL |"Value1" | NULL --------------------------- "Value2"| NULL | NULL...
1
by: Kelvin | last post by:
Hi All, How to get column value from datarow while datatable looping ? Please advised !
3
by: Peter J Ross | last post by:
Greetings. I'm quite new to PHP and have very little knowledge of programming in general, so I may be missing something obvious, but I can't find a solution to the following difficulty in either...
2
by: Shark | last post by:
Hi, I'm looking for an efficient way to do the following: "given a column of entries with double values, select the greatest value less than D", where D is given as the upper bound. so if I...
1
by: davidreid | last post by:
Could someone please show me how to add additional columns to the ListView sample download provided by Stephan Lebans (http://www.lebans.com/vb_listbox.htm)? Thanks!
0
by: vinaykumar Maladkar | last post by:
Hi All, I m using Visual studio 2005 and C#. i want to show comparative data of different cars like their price , engine , capacity etc. So i am using DataGridView. but How to group one or more...
3
Soniad
by: Soniad | last post by:
Hello, In stored procedure, i am using query that fetches 2 columns record but single row. i have used cursor to fetch single record. is there any way to fetch the record and put it in...
4
by: beemomo | last post by:
I manage to store the additional use data (username, fullname, rolecode) in FormAuthenticationTicket. However , the user has more than one role , he can be admin, poweruser , executive ,etc... can...
5
by: Mathias123 | last post by:
Hello! I have a question. I have a DataGrid with 3 columns binding (Article Quantity,Blocked Quantity & a template named Input quantity). i want to check the input QTY value. for example:...
1
by: Parita Pandya | last post by:
I am preparing a to do list in which there is Status (completed / not yet) and Task name in sheet 1. In sheet 2 (completed) the task which is marked completed is moved with the current time. Now I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.