Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Type error

Status
Not open for further replies.
corbinap

corbinap

Programmer
Joined
Nov 20, 2006
Messages
34
Location
US
I am getting an Datat Type error. I think because the fields are text but I am not sure how to change to make work. Thanks in advance.

Me.TempAssignedSalon.RowSource = "select SalonID from salon where salonid<>" ' & Me.cmbSalon
 
Sort by date Sort by votes
Perhaps this ?
Code: 
Me.TempAssignedSalon.RowSource = "select SalonID from salon where salonid<>'" & Me.cmbSalon & "'"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question Question
Form Data Not Updating
Replies
6
Views
1K
dhookom
dhookom
JanaLNelson
  • Locked
  • Question Question
Filter as you type combo box in Access
2 3
Replies
54
Views
4K
JanaLNelson
JanaLNelson
caykamanj1966
  • Locked
  • Question Question
Delete Data from Field
Replies
1
Views
472
dhookom
dhookom
TrekBiker
  • Locked
  • Question Question
Sending data to Excel
Replies
2
Views
492
TrekBiker
TrekBiker
TheresAlwaysAWay
  • Locked
  • Question Question
&quot;There isn't enough memory to perform this operation...&quot; error after upgrading from Access
Replies
2
Views
586
Axworthy
Axworthy

Part and Inventory Search

Sponsor

Back
Top