Form Not Displaying Correctly

[rfear]

When I move between forms they normally overlay one another so the current form fills the screen and any forms behind can not be seen.

That was until one of my forms contained some tabs.

Now only that part of the screen occupied by the tab is overlayed - makes for some very confusing images.

Anyone else come across this problem ?

 

[Alisa]

I haven't had this problem before, but I am wondering if it would help to make the form invisible while the user it not on it. For instance, if they could navigate between the screens using next or back buttons, and then whenever they go to a different screen, make the one they were on invisible, and vice versa. Don't know if that would work with your setup, just a suggestion.

 

[rfear]

I tried closing the form, this did what it was told however I then got left with the grey background of access. I guess making the form invisible would do the same thing.

I am reaching the conclusion that tabs are not reliable.Not only do they not display properly but now it seems I can't update the underlying data tables. I'm getting run time errors all over the place, fields that can not be found ( but they are on the form ), objects can no longer be assigned values.

Something very weird is happening, my queries appear to be locked out and I can't fathom why. Upshot is I have a database that is being a pain.

I think the best option will be to tear this database up and start again. Probably replicate the look of tabs but use macro buttons to navigate between forms.

 

[rfear]

I seem to have tripped over the solution.

My tables had no primary keys. Not only was this causing my form to fall over but also my queries.

Now that I've defined the primary keys all seems to be peaceful again.