Field Flickers with DLookUp - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Field Flickers with DLookUp

Jon Stephanou

2 years ago

I have a form with 10 input fields. When I start to type in any of the 10 Combo-Boxes the item list is displayed as expected. For each of these items I have 3 Unbound Fields, the Vendor I purchased it from, their part number and a Description of the piece. For the first item using DLookUp in each of Unbound fields everything populated correctly. However, it will not work for the other line items. Per the Tech-Help video this in the Control Source for each unbound field. For example

=DLookUp("VendorName","StockT","StockID=" & NZ([PartCombo1],0))
=DLookUp("Description","StockT","StockID=" & NZ([PartCombo1],0))

No issues with the above statements, so I changed the ComboBox from 1 to 2.

=DLookUp("VendorName","StockT","StockID=" & NZ([PartCombo2],0))

The field box flickers and you can see #Error in the field.

Any suggestions would be deeply appreciated

	Ronald de Boer @Reply 2 years ago
Hi Jon, There is no PartCombo2 you only have partCombo1. The field is flickering because ther is no PartCombo2 Regards

	Jon Stephanou OP @Reply 2 years ago
Hi Ronald, I have 10 seperate Combo-Boxes labeled, PartCombo1 thru PartCombo10 and each has a three corresponding Unbound Fields. Vendor1 thru Vendor10, Description 1-10 etc...

	Kevin Robertson @Reply 2 years ago
You say the Combo Boxes are labelled, but did you change the actual Name of each box?

	Jon Stephanou OP @Reply 2 years ago
Yes, poor choice of words, the actual name is PartCombo1, PartCombo2, etc... thru PartCombo10

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View