Recent content by lmh24

Figured it out: In the first form: DoCmd.OpenForm "hhroster", acNormal, , , , , Me.file Second form OnOpen: If Not IsNull(Me.OpenArgs) Then Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "hhroster.file = " & Me.OpenArgs If Not rs.EOF Then Me.Bookmark = rs.Bookmark End If

I will try to do this shortly, however I think I found a possible solution in some code I found on another site. But I get an error in one portion of it. If anyone can help me figure out what's wrong with this, it may solve the issue. In the After Update section for the last field (begin) on...

Okay, so I figured out the problem, but I don't know how to fix it. What I have is a series of forms connected by their primary keys, all called FILE. When a certain value is entered on the first form (Screening), the user is taken to the next form (Household). It is this form that is the...

The primary key is FILE -- a unique ID that I've assigned -- and the foreign key is the same, i.e. the corresponding FILE ID in the subform table. It's been awhile since I've used Access, and the relationship structure is a little fuzzy, so if I'm relating them improperly, I would be grateful...

There is a (numerical) value on the main form (hhroster) that tells the subform in how many records to allow entry for that particular unique ID (FILE). Once a number is selected in that field in the main form, the focus is set to the subform and only that many records can be entered. Then the...

Yep, everything else seems to be working fine. And when I don't have the "requery" code commented out I don't get an error -- it just doesn't do anything. Thanks.

Yes, I have set them up - there is a field in both forms by which I have linked them. This does not solve the problem. Thanks.

Hello, I have a survey questionnaire that I'm building in Access where each unique record corresponds to a household, designated by the primary key FILE. Most of the data to be entered in this database will be in one row, i.e. data about one selected individual in the household. However, I...

VilaRestal, Thank you for your reply. To clarify, this is a survey questionnaire, so the idea is that with every new household an interviewer approaches, they will be opening a new record for that household, which will be associated with a unique file number (FILE). They will then ask the...

Hello there, I am attempting to design a survey questionnaire in Access 2010, and this is the first time I've used Access in several years. My SQL is rusty, and my VBA skills are introductory. Currently I need to figure out a way to do the following tasks to create an overall function: 1)...