Make text box visible based on info in table

A

AFoster

Hello

I am trying to put on my form a text box that is only visible if data there
is data in a table based on the current client. Basically I have a form with
all my clients listed and than i have a table with all of my payments for all
my clients. So i want to create a text box to show up if there are payments
in the table based on the current clients SSN. The SSN is on the form and in
the Master Payments Table. Everytime I try to create a macro based on a
condition where Forms![Account List1]![ssn] = [Master Payments]![SSN] to
change the visible value to true on the text box i get an error saying
something about no automation on that object or something

Could someone please help on this subject I really need this to work.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Link a text box based on drop down box with four options MS Word 365 0
Refresh field 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Access 2010 DB not fuctional with multiple users 2
Make Payment and Deduct from Bill 2
Subform linked to master by SSN 3
Add Payment without manually entering the balance 3

Top