Frustrated Question

I have 2 databases. One I use for testing and the other is my real data. I
setup my test one to have a form with a subform that has another subform in
it. Works fine. I try to simulate on my real data and can not make the
subform have a subform in datasheet view. I'm I missing something? I even
imported the form from my test site and when I do it loses the subform. I
can view the 1st subform by itself but the minute I drag it into the main
form it loses the subform. Hope this makes sense. Any suggestions.

Hi John,
I don't know a direct answer to your frustration but when I want to use test
data, I have 2 separate backends - one for the test data, one for the real
data. I just swap backends and use the same frontend. Saves a lot of extra
work.
Maybe the following will help??
--Save your work in both databases.
--Close both databases
--Close Access
--Open each database and make a backup
--Open each database and do a compact repair
--Try the troublesome database again

Jeanette Cunningham




"John C." wrote in message
...
I have 2 databases. One I use for testing and the other is my real data.
I
setup my test one to have a form with a subform that has another subform
in
it. Works fine. I try to simulate on my real data and can not make the
subform have a subform in datasheet view. I'm I missing something? I
even
imported the form from my test site and when I do it loses the subform. I
can view the 1st subform by itself but the minute I drag it into the main
form it loses the subform. Hope this makes sense. Any suggestions.

Are these on different machines? Running the same version of Access?
Including Service Pack updates?

--
HTH,
George


"John C." wrote in message
...
I have 2 databases. One I use for testing and the other is my real data.
I
setup my test one to have a form with a subform that has another subform
in
it. Works fine. I try to simulate on my real data and can not make the
subform have a subform in datasheet view. I'm I missing something? I
even
imported the form from my test site and when I do it loses the subform. I
can view the 1st subform by itself but the minute I drag it into the main
form it loses the subform. Hope this makes sense. Any suggestions.

"can not make the subform have a subform in datasheet view."

Are you saying that you have a subform (in Datasheet View) and have added a
second subform to this one, and the second one doesn't appear? If this is the
situation, this is normal Access behavior. In Design View, you can add
controls, such as command buttons, comboboxes, subforms, etc. to a Datasheet
form, but when you run the form, these controls will not show.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200712/1