Is there a way to create skip patterns in an Access Form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have a skip pattern for a database I am creating for data
entry of a survey. Depending on the response to one question it may not be
necessary for the next question and it needs to be skipped.
 
SEPRT said:
I would like to have a skip pattern for a database I am creating for
data entry of a survey. Depending on the response to one question it
may not be necessary for the next question and it needs to be skipped.
Click to expand...

You can use code in the AfterUpdate event of one control to check its
value and, if necessary, SetFocus to another control.

I don't know if you're interested in looking at Duane Hookom's "At Your
Survey" database, downloadable from

http://www.rogersaccesslibrary.com/OtherLibraries.asp

I'm not familiar with it myself, so I don't know if it implements the
"skip" feature you describe or not, but it is often recommended as a
good model of a survey database.
 
Back
Top