2 Subforms: 1 data entry, 1 to view records

[lydonw]

With any luck this should have a simple solution, but I can't figure it out.

I have a form (Consumers) that displays consumer information. On the lower half of the form are two subforms. The bottom subform (Authorizations) shows records from the many side of a one to many relationship, linked by the primary key consumerID. The other subform is to be used only for entering data, and should otherwise be blank. When data entered in the top subform, the bottom should be re-queried.

Unfortuatenly, I can't get that far. No matter what I try, the "data entry" subform is never blank. Data Entry is set to Yes, I've tried it with a query and table source (same result), and multiple view types single form/continuous/datasheet.

Consumers Form source is a query
Authorizations subform source is a query.

Is there some simple setting or group of settings that prevent the data entry mode, or are required for data entry mode? Most of the posts I've seen on the subject have this just simply working, so I haven't gotten much help from them.

 

[lydonw]

Relevant. The data entry form fields are bound. Should they be unbound?

 

[pbaldy]

They should be bound. Can you post the db?

 

[lydonw]

Ok, it is attached. In particular, look at the consumers form under the Authorizations tab/page.

I have 2 subforms there, the top one should be blank and used only for data entry.

The data should look like shit since I did about 10 find/replace to randomize what was in there. There is also a fair amount of bloat in there since I keep having to work on one part, then another.

As a side note, I've been looking at another solution (http://www.rogersaccesslibrary.com/forum/adddataattopmdb_topic145.html) although it seems unnecessarily complicated.

*I am leaving the office, but will try to check back over the weekend for responses.

 

[pbaldy]

Offhand I don't see why it's failing, but I'll look at it further when I can. A.D. comes up with some very slick solutions, but I haven't looked at that particular one.

 

[lydonw]

I appreciate the help. Yeah,I haven't the foggiest why it is failing either (obviously). I've got my fingers crossed

 

[lydonw]

Any luck finding where this thing got broken pbaldy? I'm not sure what the heck I'm doing wrong!

 

[lydonw]

Is there anyone that can help on this? I'm still struggling to figure out why this subform will not work for data entry only.

Anyone?

 

[lydonw]

I'm still drowning here. Is there anyone that can help? opening the subform by itself shows a blank data entry form, but when it is a part of the main form the field are not blank. I've tried messing with the subform source (either a query or table, but both with the same information). I've removed some filtering data from the query, that didn't do it.

I added this line into the Open event of the subform "DoCmd.GoToRecord acDataForn, "quAuthorizations", acNewRec" to no effect (I saw it suggested somewhere).

I have absolutely no clue what is going on.

 

[lydonw]

This may have been an issue with the database, possibly corrupted. I rebuilt and everything works fine.

Still not sure what the problem was.

 

[pbaldy]

Thanks for reporting back. That was certainly a stumper; I should have thought of corruption and suggested rebuilding that form.