mayskys1999
Last Activity: Feb 8 '13, 09:12 PM
Joined: Feb 5 '13
Location:
-
The Row Source is Model and Row Source Type is Text. -
Seth,
I try using a combo box to select Revision to be entered in to the form of ProductsReport. That is my goal.
Thanks for your help.Leave a comment:
-
Seth,
Models table has Text data in Revision row and
ProdReport table has Text date in Firmware row either.
for my understanding is ModelID could be control to pick up right record when pick up model. Is that right ?
Plese help me to understand more and help if I'm getting wrong.
ThanksLeave a comment:
-
I'm sorry.
that is Auto Number.Leave a comment:
-
Seth,
those are Number.Leave a comment:
-
Seth,
ModelID is PK data.Leave a comment:
-
I used your code to my project.
I try to use cmb_SelectModel ID_AfterUpdate.
the immediate window showing ModelID = CCC when I picked the third model.Leave a comment:
-
I would like to do like this.
whenever I pick up a model from cmb_SelectModel ID_AfterUpdate( )
It will take right Revision from Models table to put in Firmware of ProductsReport form.
Thanks for your support.Leave a comment:
-
Thanks for your comment.
I'm new and try to learn. Please forgive any mistake I did.
Actualy I don't know what I have to do to make it work. I tried so many ways but my project doesn't work.Leave a comment:
-
Thanks for your help.
I inserted your code but function still get error. Run-time error '2471. and next line is showing the expression you enter as a query parameter produced this error: 'CCC"
Could you please help me again.
thanks alot...Leave a comment:
-
I tried your but still showing errorLeave a comment:
-
Dlookup function just pick the first record ?
Hello to All Expert.
I'm new in here and need your help.
I have 2 tables Models and ProdReport. I have form name ProductsReport. I made Dlookup function in Model drop down to seclect model from table Models. I would like to have right Revision in Models table will pick up to insert in field Firmware section in the form ProuctsReport.
Here is my work.
...Code:Private Sub Model_AfterUpdate() Firmware = DLookup("[Revision]",
No activity results to display
Leave a comment: