General discussion


Access 97 problem with form and records

By Norin ·
Hello, I am currently working on a project but I recently encountered a problem which I cant find the solution, so here it is:
I have my form which contains all the records and I want to make a little checkup before it shows the record details... But when I put my code which is similar to this exemple:
If me.txtTest.value <> "" then
me.cboTest.Enabled = false
End if

It simply dont work... I'm adding this code to the form_open thing but it keeps the result, so if my 1st record was true well ALL other records will be which is something I dont want at all.

Thanks in advance.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by dryflies In reply to Access 97 problem with fo ...

How about you just tell us what you want to do. If you are trying to validate data, I would do that either in a query prior to loading the form or set the validation properties for your form.
if you want to have a calculated field in your form, then I would go to the field on the form where the me.txtTest.value is displayed and have it set me.cboTest.Enabled during the drawing or redrawing of the field.

please rate my answer

Collapse -

by sgt_shultz In reply to Access 97 problem with fo ...

you are not resetting your test variable temp spot or something. you are looping before you think or something. you need to learn to set a watch on a variable(s) and step thru your code in the access vba editor. if you got this far you can figure out how to do that and it is very powerful for taking next step in learning to code imho. check out access vba Help. if you do not have working access vba help (this is not the regular access Help files, it is special help files you get from Help within vba editor and may or may not be installed), post back if you need help isntalling it. or research that yourself fairly simple at

Related Discussions

Related Forums