Dlookup in a form

P

Patti

Hi!

I'm trying to autofill a form using Dlookup and it's not
working. The controlling field is cmbRFCE. In the
AfterUpdate field, I have the following:

Private Sub cmbRFCE__AfterUpdate()
[cmbProject] = DLookup("[Project]", "tblRFCE", "[RFCE]=" &
[Forms]![PO]![cmbRFCE])
[cmbDept] = DLookup("[Dept]", "tblRFCE", "[RFCE]=" &
[Forms]![PO]![cmbRFCE])

End Sub

It doesn't give me any errors, but the cmbProject and
cmbDept fields don't populate. In those combo boxes, the
rowsourcetype is set to Table/query and the row source is
a query: SELECT tblRFCE.[Project] FROM tblRFCE WHERE
(((tblRFCE.[RFCE])=[Forms]![PO]![cmbRFCE])); The Dept
combo box has the same query but it selects tblRFCE.[Dept]

What am I doing wrong?
 
R

Reggie

Patti, Instead of doing a DLookUp, since you already have a query/sql statement that will return the
results you want just requery those controls in the AfterUpdate event:

Private Sub cmbRFCE__AfterUpdate()
Me.[cmbProject].Requery
Me.[cmbDept] .Requery
End sub

Hope I understood correctly and that this helps.
 
P

Patti

Hi Reggie,

It's still not working. No error, but no data -- just
headers! Since it's pulling the headers, I assume it's
reading the right field in the table, but it's not
recognizing the matching field with cmbRFCE. Any ideas?
-----Original Message-----
Patti, Instead of doing a DLookUp, since you already have
Click to expand...
a query/sql statement that will return the
results you want just requery those controls in the AfterUpdate event:

Private Sub cmbRFCE__AfterUpdate()
Me.[cmbProject].Requery
Me.[cmbDept] .Requery
End sub

Hope I understood correctly and that this helps.

--
Reggie

----------
Hi!

I'm trying to autofill a form using Dlookup and it's not
working. The controlling field is cmbRFCE. In the
AfterUpdate field, I have the following:

Private Sub cmbRFCE__AfterUpdate()
[cmbProject] = DLookup("[Project]", "tblRFCE", "[RFCE] =" &
[Forms]![PO]![cmbRFCE])
[cmbDept] = DLookup("[Dept]", "tblRFCE", "[RFCE]=" &
[Forms]![PO]![cmbRFCE])

End Sub

It doesn't give me any errors, but the cmbProject and
cmbDept fields don't populate. In those combo boxes, the
rowsourcetype is set to Table/query and the row source is
a query: SELECT tblRFCE.[Project] FROM tblRFCE WHERE
(((tblRFCE.[RFCE])=[Forms]![PO]![cmbRFCE])); The Dept
combo box has the same query but it selects tblRFCE. [Dept]

What am I doing wrong?
Click to expand...


.
Click to expand...
 
P

Patti

Well I just got it to work. I set the bound column to 1
on cmbRFCE. That did the trick but I don't know why! I
haven't quite figured out what "bound columns" means!
-----Original Message-----
Hi Reggie,

It's still not working. No error, but no data -- just
headers! Since it's pulling the headers, I assume it's
reading the right field in the table, but it's not
recognizing the matching field with cmbRFCE. Any ideas?
-----Original Message-----
Patti, Instead of doing a DLookUp, since you already
Click to expand...
have
a query/sql statement that will return the
results you want just requery those controls in the AfterUpdate event:

Private Sub cmbRFCE__AfterUpdate()
Me.[cmbProject].Requery
Me.[cmbDept] .Requery
End sub

Hope I understood correctly and that this helps.

--
Reggie

----------
Hi!

I'm trying to autofill a form using Dlookup and it's not
working. The controlling field is cmbRFCE. In the
AfterUpdate field, I have the following:

Private Sub cmbRFCE__AfterUpdate()
[cmbProject] = DLookup("[Project]", "tblRFCE", "[RFCE] =" &
[Forms]![PO]![cmbRFCE])
[cmbDept] = DLookup("[Dept]", "tblRFCE", "[RFCE]=" &
[Forms]![PO]![cmbRFCE])

End Sub

It doesn't give me any errors, but the cmbProject and
cmbDept fields don't populate. In those combo boxes, the
rowsourcetype is set to Table/query and the row source is
a query: SELECT tblRFCE.[Project] FROM tblRFCE WHERE
(((tblRFCE.[RFCE])=[Forms]![PO]![cmbRFCE])); The Dept
combo box has the same query but it selects tblRFCE. [Dept]

What am I doing wrong?
Click to expand...


.
Click to expand...
.
Click to expand...
 
B

berk

The original way you did dLookup refers to a data type
of "number" not "string". So, if the bound field of
combo box you are referring to is a number, then it will
work. If it is not, you have to add some "'"
(apsotrophes) to you code like this:

[cmbDept] = DLookup("[Dept]", "tblRFCE", "[RFCE]='" &
[Forms]![PO]![cmbRFCE] & "'")


-----Original Message-----
Well I just got it to work. I set the bound column to 1
on cmbRFCE. That did the trick but I don't know why! I
haven't quite figured out what "bound columns" means!
-----Original Message-----
Hi Reggie,

It's still not working. No error, but no data -- just
headers! Since it's pulling the headers, I assume it's
reading the right field in the table, but it's not
recognizing the matching field with cmbRFCE. Any ideas?
-----Original Message-----
Patti, Instead of doing a DLookUp, since you already
Click to expand...
have
a query/sql statement that will return the
results you want just requery those controls in the AfterUpdate event:

Private Sub cmbRFCE__AfterUpdate()
Me.[cmbProject].Requery
Me.[cmbDept] .Requery
End sub

Hope I understood correctly and that this helps.

--
Reggie

----------
Hi!

I'm trying to autofill a form using Dlookup and it's not
working. The controlling field is cmbRFCE. In the
AfterUpdate field, I have the following:

Private Sub cmbRFCE__AfterUpdate()
[cmbProject] = DLookup
Click to expand...
("[Project]", "tblRFCE", "[RFCE]
=" &
[Forms]![PO]![cmbRFCE])
[cmbDept] = DLookup("[Dept]", "tblRFCE", "[RFCE]=" &
[Forms]![PO]![cmbRFCE])

End Sub

It doesn't give me any errors, but the cmbProject and
cmbDept fields don't populate. In those combo
Click to expand...
boxes,
the
rowsourcetype is set to Table/query and the row
Click to expand...
source
is
a query: SELECT tblRFCE.[Project] FROM tblRFCE WHERE
(((tblRFCE.[RFCE])=[Forms]![PO]![cmbRFCE])); The Dept
combo box has the same query but it selects tblRFCE. [Dept]

What am I doing wrong?


.
Click to expand...
.
Click to expand...
.
Click to expand...
 
P

Patti

Thanks!
-----Original Message-----
The original way you did dLookup refers to a data type
of "number" not "string". So, if the bound field of
combo box you are referring to is a number, then it will
work. If it is not, you have to add some "'"
(apsotrophes) to you code like this:

[cmbDept] = DLookup("[Dept]", "tblRFCE", "[RFCE]='" &
[Forms]![PO]![cmbRFCE] & "'")


-----Original Message-----
Well I just got it to work. I set the bound column to 1
on cmbRFCE. That did the trick but I don't know why! I
haven't quite figured out what "bound columns" means!
-----Original Message-----
Hi Reggie,

It's still not working. No error, but no data -- just
headers! Since it's pulling the headers, I assume it's
reading the right field in the table, but it's not
recognizing the matching field with cmbRFCE. Any ideas?

-----Original Message-----
Patti, Instead of doing a DLookUp, since you already have
a query/sql statement that will return the
results you want just requery those controls in the
AfterUpdate event:

Private Sub cmbRFCE__AfterUpdate()
Me.[cmbProject].Requery
Me.[cmbDept] .Requery
End sub

Hope I understood correctly and that this helps.

--
Reggie

----------
message
Hi!

I'm trying to autofill a form using Dlookup and it's not
working. The controlling field is cmbRFCE. In the
AfterUpdate field, I have the following:

Private Sub cmbRFCE__AfterUpdate()
[cmbProject] = DLookup ("[Project]", "tblRFCE", "[RFCE]
=" &
[Forms]![PO]![cmbRFCE])
[cmbDept] = DLookup("[Dept]", "tblRFCE", "[RFCE]=" &
[Forms]![PO]![cmbRFCE])

End Sub

It doesn't give me any errors, but the cmbProject and
cmbDept fields don't populate. In those combo boxes,
the
rowsourcetype is set to Table/query and the row source
is
a query: SELECT tblRFCE.[Project] FROM tblRFCE WHERE
(((tblRFCE.[RFCE])=[Forms]![PO]![cmbRFCE])); The Dept
combo box has the same query but it selects tblRFCE.
[Dept]

What am I doing wrong?


.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

two questions on exporting from a form 3
IIF statement in criteria not working 2
Using Dlookup in form - New to Access 3
dlookup 2
DLookup on Text Box 1
Using A Dlookup Function On A Form When A Combo Box is Updated 2
Continuous Form - Populate unbounded field 1
calendar box on form 2

Top