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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can you auto-lookup in a list box in VB?

Status
Not open for further replies.
NeoZakz

NeoZakz

Technical User
Jul 22, 2002
25
US
Private Sub days_after_AfterUpdate()

If IsNull(Me![Combo119]) Then
Me![Date Due] = DateAdd("d", Me![Seq], Me![Date Due])
Else

DLookup("[Miledate]", "Mile1", Me![Date Due].Value = Me![Combo119].Value) = Me![Date Due].Value = DateAdd("d", Me![Seq], Me![Date Due].Value)

End If
End Sub

The Me![Combo119] are what im trying to get to look up the values based on whats in the fields already but it keeps asking for a permanent value to lookup is there a way to get it to check whats in the list box and look that up?
 
Status
Not open for further replies.

Similar threads

renigar
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
343
renigar
renigar
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
548
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
531
TheresAlwaysAWay
TheresAlwaysAWay
ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
365
mattKnight
mattKnight
Trob70
  • Locked
  • Question
There is no object in this control 1
Replies
9
Views
397
Trob70
Trob70

Part and Inventory Search

Sponsor

Back
Top