Recent content by Suzanne Joy

It did the job! Thank you SO much! I also removed all the click code and will take your advice the next time I post a .jpg. Thanks again and have a great day, Suz.

Please see attached. Let me know if this is not what you're looking for.

The field name is definitely Prem_State. Thanks again for your willingness to help! Suz.

Sorry - It looks as if I can't get my .zip file small enough to post here. I appreciate the help, though. Suz.

Thank you, Stormin_norm, but that didn't seem to work. I had tried that before I created all the code, but was willing to try it again. Any suggestions? I've attached the .mdb (zipped), if you'd like to look at my form. Go to frmGDB_Prem. Pls. excuse the messy format -- I am still designing...

I have premisis information and contact information and want the premisis information to automatically default into the contact text boxes. This is working well for all fields, but the State field. I've attached the code. What am I doing wrong? Private Sub Contact_Last_Name_AfterUpdate()...

I need to create a combo box whose drop-down options are controlled by what is selected in a preceding textbox. How do I set this up? Specifically, I need for state-specific county FIPS codes to appear in the drop-down list of the combo box when a specific state is selected in a state textbox...

Very funny.;)

When I created the original table, I was basing the table on a form I had been given. I put all the fields on the form into one table. Later, the End User informed me that half the fields should be linked to, and therefore populate, a separate table.

Thanks for getting back with me so soon. I appreciate the help.

I have created a data entry form in which all the fields are bound to fields in one table. However, I have been informed that some of the fields in the table actually belong in a separate table, which I have now created. The properties of the fields in the second table are identical to those...