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!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Cherry2005
-
Compound foriegn key in lookup field?
This is very much like the problem I'm having. Part # Machine # Scrap amount a 1 x a 2 y a 3 x b 1 y b 2 x c...- Cherry2005
- Post #4
- Forum: Microsoft: Access Other topics
-
Validate partnumber before lose focus
Parts is the Table Daily Transactions is the data entry form Is this close? Thanks for all your help!! Private Sub Part_Number_LostFocus() Dim Part_No As String Part_No = DLookup("[Part#]", "Parts", "[Part#]= " _ & [Forms]![Daily Transactions]![Part#] & "'") If IsNull(Part_No)...- Cherry2005
- Post #4
- Forum: Microsoft: Access Forms
-
Validate partnumber before lose focus
I have a field "Part#" (text)in the daily transactions table. When data entry person enters Part # in the form, I want to make sure the part # is a valid Part # according to a field called "Part#" in the table called Parts. If it does not exist in the Parts talble, I want a message to pop up. Is...- Cherry2005
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
