OnClick Event Breaks Field - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

OnClick Event Breaks Field

John Arnett

2 years ago

I added an On-Click event to a form and it broke one of the fields in the form. The form is based on a table of work locations and in that table, the country field is a combo box that is connected to another table of a list of countries. The On-Click is sorting out the closed work locations and it is functioning properly, but the country field now displays #NAME? when the On-Click event is triggered.
This is the event......Me.RecordSource = "Select * FROM PropertyInfoTbl WHERE SiteClosed=True".

Any ideas would be very much appreciated.
John

	Sami Shamma @Reply 2 years ago
Check the Name property of "Country Field." It is almost guaranteed to be misspelled.

	Kevin Robertson @Reply 2 years ago
Does PropertyInfoTbl have the field? Screenshots???

	John Arnett OP @Reply 2 years ago

	John Arnett OP @Reply 2 years ago

	John Arnett OP @Reply 2 years ago

John Arnett OP @Reply

2 years ago

I appreciate your comments. I checked the CountryName spelling everywhere it exists but I didn't see anything misspelled. I wasn't really clear on what "Name Property" means though.

I also checked the PropertyInfoTbl and you are correct, the CountryName field does not exist there. The PropertyInfoTbl and the CountryTbl are connected via the primary key of the CountryTbl so the field in the PropertyInfoTbl is actually "CountryID".

	Sami Shamma @Reply 2 years ago
What is the record source for Form "PropertyListFrm"?

	John Arnett OP @Reply 2 years ago
The record source for that form is the PropertyInfoTbl.

	Sami Shamma @Reply 2 years ago
There is your problem. "ContryName" is not on that table. you need to create a query that will bring the ContryName or use a combo box.

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

Next Unseen

New Feature: Comment Live View