Link to home
Start Free TrialLog in
Avatar of bill201
bill201

asked on

i'm not able to make a row source update depend on a value in a other field in access 2010

hi

i have a database that have a form with the name "orderdetailsf", and i want that when i update a combo field with the name "modelcombo" that the combo box "sizecombo" row source  will be update, but when i update the "modelcombo" the size combo is empty  

and there is my code
and i attach also my database
Dim StartSize
Dim EndSize
StartSize = DMax("startsize", "modelt", "modelid=" & ModelCombo)
EndSize = DMin("endsize", "modelt", "modelid=" & ModelCombo)
SizeCombo.RowSource = "SELECT SizeID, Size " & _
                        " FROM SizeT " & _
                       " WHERE Sizeid Between " & StartSize & " AND " & EndSize & "

Open in new window

sample.zip
SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bill201
bill201

ASKER

thanks thousand  times for your fast answer
it's working geat but please tell me what you do
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bill201

ASKER

unbelievable:) this all !?