how to make fields fill in automatically?

K

killerwhale65

Registered User.
Local time
Today, 14:00
Joined
Jun 28, 2004
Messages
32
Hi all,

I have a table with three colums. Every time when i enter value A in the first culum, value B must be entered in the second and C in the third colum.
I was wondering hwo i could automate that process? Every time i enter something in the first colum, i want access to look up the values for the second and third colum.

How can i make this possible?

Thanks for your help!

Matt
 
What values are going into B & C? Can't you make A a combobox with B & C selected in as hidden columns.
 
Mile-O-Phile said:
What values are going into B & C? Can't you make A a combobox with B & C selected in as hidden columns.
Click to expand...

I could indeed make A a combo box. But when i enter a value that is not already in the combo box, will it then be updated? And how do i let it fill B and C in automatically then?

B & C should not be hidden, they must be displayed.
 
killerwhale65 said:
I could indeed make A a combo box. But when i enter a value that is not already in the combo box, will it then be updated? And how do i let it fill B and C in automatically then?
Click to expand...

Look in the FAQ forum for examples of adding values not in a combobox to a table.

And as for B & C being hidden. If these are in the table with A then you don't need to store them again. You just need to select them in the same query that acts as the RowSource for the combobox and set their columnwidths to 0.

The textboxes of B & C then refer to the hidden columns of the combobox A.
 
hmmm, ok. I dont fully understand it yet, but i will check it out and try some things.

Thanks already!

Matt
 
one last question: is it possible to have a combobox in table-view? Or only in form-view?
 
Matt, Have looked at using a dlookup function?
 
You tell it a table to look in, the field to look in, and a parameter for the search, and it looks up that value.

dlookup(feildname, tablename, searchcriteria)

Look it up in the Access help.
 
it seems i am unable to auto update B and C when i select an item in the A combobox. How do i do that?
 
Last edited:
'it seems i am unable to auto update B and C when i select an item in the A combobox. How do i do that?'

Sorry - Are you working through Miles's solution or the dlookup() solution?
 
allright that works fine.

But now i'm facing the following problem. When i enter a value in the combobo that is not yet listed, then it does save that value in the underlaying table, but i cannot enter anything in B or C, as those are linked to the combo. How can i get around here?
 
You must log in or register to reply here.

Similar threads

M
Binding vs display value
Replies
5
Views
486
monika_V
M
D
Setting up a conditional column in power query, using values in a separate table to check if they are in 2 columns.
Replies
1
Views
411
arnelgp
arnelgp
H
Solved Query for the balance stock material
Replies
8
Views
557
GPGeorge
GPGeorge
K
How to remove duplicate values when multiple tables are joined
Replies
18
Views
1,421
Pat Hartman
P
E
Solved Refer to Subform control
Replies
9
Views
448
cheekybuddha
cheekybuddha

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom