In excel it would be a vlookup

[Guest]

How do I populate a field on a form from data in another field. Here is my
example
I have a sub-form that pulls data from a table called skills. That table has
the following fields skills, e_rate, m_rate, min_rate,skill_type. the three
fields skills,min_rate and skill_type are constant. for example skills =
Windows XP , min_rate = 5, skill_type = OS. I have created a combo list so
the user can select the skill. what I want is for the min_rate and skill_type
to get populated with the information in that row. Can't seem to find out how
to do this. In excel I would be doing vlookup to populate the cells.

Can anyone shead some light on this for me. my email is (e-mail address removed)

 

[Guest]

In the control source of the text box you can write
=[ComboName].column(1)

The column number start with 0

==============================
Or, on the after update of the combo you can write

Me.[TextBox1]=Me.[ComboName].column(1)
Me.[TextBox2]=Me.[ComboName].column(2)

 

[Guest]

Thanks I had seen that but cant figure out how do write the experssion. all I
keep getting is the =[Skills].[column](1) is that because this is a subform?
Why can't I use a SELECT?

In the control source of the text box you can write
=[ComboName].column(1)

The column number start with 0

==============================
Or, on the after update of the combo you can write

Me.[TextBox1]=Me.[ComboName].column(1)
Me.[TextBox2]=Me.[ComboName].column(2)

--
\\// Live Long and Prosper \\//
BS"D

How do I populate a field on a form from data in another field. Here is my
example
I have a sub-form that pulls data from a table called skills. That table has
the following fields skills, e_rate, m_rate, min_rate,skill_type. the three
fields skills,min_rate and skill_type are constant. for example skills =
Windows XP , min_rate = 5, skill_type = OS. I have created a combo list so
the user can select the skill. what I want is for the min_rate and skill_type
to get populated with the information in that row. Can't seem to find out how
to do this. In excel I would be doing vlookup to populate the cells.

Can anyone shead some light on this for me. my email is (e-mail address removed)

 

[Guest]

You can use a select, but it mean that you need to search the table again for
the record, so it can make things slower
To use a select, check help on DLookUp in Access to search for specific
field value in a specific record

DLookUp("FieldName","TableName","NumberFieldName = " & [Parameter])

Or
DLookUp("FieldName","TableName","TextFieldName = '" & [Parameter] & "'")

Or
DLookUp("FieldName","TableName","DateFieldName = #" & [Parameter] & "#")


--
\\// Live Long and Prosper \\//
BS"D

Thanks I had seen that but cant figure out how do write the experssion. all I
keep getting is the =[Skills].[column](1) is that because this is a subform?
Why can't I use a SELECT?

In the control source of the text box you can write
=[ComboName].column(1)

The column number start with 0

==============================
Or, on the after update of the combo you can write

Me.[TextBox1]=Me.[ComboName].column(1)
Me.[TextBox2]=Me.[ComboName].column(2)

--
\\// Live Long and Prosper \\//
BS"D

How do I populate a field on a form from data in another field. Here is my
example
I have a sub-form that pulls data from a table called skills. That table has
the following fields skills, e_rate, m_rate, min_rate,skill_type. the three
fields skills,min_rate and skill_type are constant. for example skills =
Windows XP , min_rate = 5, skill_type = OS. I have created a combo list so
the user can select the skill. what I want is for the min_rate and skill_type
to get populated with the information in that row. Can't seem to find out how
to do this. In excel I would be doing vlookup to populate the cells.

Can anyone shead some light on this for me. my email is (e-mail address removed)