Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

data validation

ResolvedVersion 2007

Charlotte has attended:
Access Introduction course
Excel VBA Introduction course

Data Validation

Hi There,

I was wondering if there is anyway you can create a data validation in a form in access which references another table?

Thanks

Charlotte

RE: Data Validation

Hi Charlotte,

Thank you for your question.

Could you please provide me with some more details.

Do you mean like an IF statement that tests the value in a table and places an answer in a from field that matches the criteria set?

Regards

Simon

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 20 Dec 2012: Automatically marked as resolved.

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.