Search results

Doesn't matter. I took it out and got the same error message on the next line.

I changed the first tblRequest line to: Me![tblRequestVolunteers subform].Form.RowSourceType = "Table/Query" Now I get the following error message: Application defined or object defined error. What now?

I'm trying to use cascading combo boxes, where the second box is on a subform. I've found several examples of code to put on the first box after update action that require setting the record source for the second box. However, every structure I've tried for referring to the second box fails with...

We did it! It needed a bit more tweeking, but with your help I figured it out. Once again, thanks much

We're almost there. Now it's complaining that I haven't supplied the right number of values for the table I'm updating. The table has only two columns. The first one is the primary key and defined by AutoNumber. The second is the field I'm trying to fill in. Do I need something other than FKID?

My form has a subform called subformDestinations that has one field Destinations. When I type in that field the record that is the record source for the main table gets updated correctly. Outside the subform there is a button to add the new value to a lookup table. I tried the following code in...

Ureka! As soon as I changed it, the form filled out, even in Layout View. Thanks so much.

The record source is a query. DATA ENTRY is set to Yes.

Form frmEnterMemberRequests goes to frmServicesByMember to find a specific request. Eventually that will return to frmEnterMemberRequests, but for now it goes to frmEnterMemberRequests2. The code I showed above is in Open for frmEnterMemberRequests2. The problem has been to get the form to load...

Didn't help. Here's the complete On Open code: Private Sub Form_Open(Cancel As Integer) Dim strRequestID As String Dim rst As DAO.Recordset Dim lngID As Long Set rst = Forms!frmServicesByMember.RecordsetClone lngID = TempVars!RequestID rst.FindFirst...

It is the primary key in the record source and it is a control on the form.

OK, Thanks. Now I have the correct value in lngID, but on the next line I get "The Microsoft Access Database engine does not recognize 'RequestID' as a valid field name or expression." That line is: rst.FindFirst "[RequestID]=" & lngID What next?

I have a form in which users are expected to enter request data, but not all the data is known at the beginning. A button on the page takes you to another form for finding an existing request. When you select the one you want by clicking on an "edit" button, you are taken back to the first form...

Hi, I just joined because I have recently become, by default, the DBA for a new non-profit. I was lucky enough to inherit the basics of the database from another group in the same domain, but a few things don't work and we want to make some changes. I have already learned a lot by searching and...