sub-sub form for neuropsych tests

[aytee111]

I'm not the best at form design, I do like it neat and tidy. Here's what I have been talking about.

[neuropsychresearch]

The disappearing tabs syndrome is caused by tabbing - set all the subforms to tab stop = No.

I need to learn a bit of visual basic to do that. But that will be very helpful.

Do you think that using a two level navigation form would help clean up data entry for so many fields?

[aytee111]

Nothing to do with VBA, it is a property on the subform.

Not sure what you mean by two-level form?

[neuropsychresearch]

how do you access the tabstop setting? via properties of the tabbed box?

i meant a navigation form

[neuropsychresearch]

strange. i found tab stop and set it to 'no,' it didn't affect the tab at all..

[aytee111]

When you have the demo form open in design view, click on the RBANS subform (maybe twice) until the subform is highlighted. The properties box will say "subform" at the top. Under the All tab the Tab Stop property is near the bottom.

Oh, I don't use nav forms so don't know how they work. Us old school people just make forms the way we want them, lol.

[aytee111]

i found tab stop and set it to 'no,' it didn't affect the tab at all..

Not sure what you mean, this was answering the disappearing act.

[neuropsychresearch]

it's difficult to explain. i set the tabstop to no, but each time i click on a tab, it scrolls up or something. you have to click on the margin to get it to reappear...

[aytee111]

Did you set the property on all the subforms?

[neuropsychresearch]

hm. i think tabstop doesn't help with the problem i mentioned. when i click a tab, it goes up a bit and i have to click the margin to get the tab box to reappear. irritating

[neuropsychresearch]

you were right. i did that and now voila it doesn't disappear.

are you famliar with navigation forms? would they be helpful here?

how much visual basic do i need to learn to use that cool tip you showed me earlier about userupdate, i think it was

[aytee111]

Trying to figure out what VBA I did for you! What was it in connection with?

I don't know about nav forms. I think it would help you if you could figure out the best way to get the forms to work and then make it happen, either thru nav forms or thru designing your own.

[neuropsychresearch]

Trying to figure out what VBA I did for you! What was it in connection with?

I don't know about nav forms. I think it would help you if you could figure out the best way to get the forms to work and then make it happen, either thru nav forms or thru designing your own.

it was how to make a block appear only when some info had been typed in. it was something like Update or AfterUPdate .... ?

[aytee111]

If you're refering to making something visible/invisble, that was in the database I posted a few posts ago. You decided not to go that route, however. You would have something like a list box of all the test names, or else a command button for each test, and when the user selected a test its subform would become visible. That code is still attached to that post.

[neuropsychresearch]

well i postponed it because it was too complex for me at that point. but now that can pass IDs and use tabs - would it be possible to merge them so that on each tab, which would be a domain such as "attention" or "memory" - inside each tab would be the combo box that would make a given test appear? poof! it would be beautiful if I could get it to work.

I saw your code but it was confusing. I don't know vba. not yet. but is the idea possible? to merge tabbed control with command button for visibility?