Split form in Subform

[agehoops]

I'm trying to use a split form so that it shows normal controls and a datasheet. I'm able to do this easily on a normal form, but it isn't working on a subform. Is it not supposed to, or is there just some proper way of doing it?

Thanks

 

[RuralGuy]

I'm not sure what you are asking. Do you have a picture or sample db? Did you put a SubForm in DataSheet mode on your form?

 

[agehoops]

Ok just put a picture on of the split form now. Basically, in Access 2007 there is a new form view which is split. It allows you to have all of your normal fields on the form like a standard form view, and then have them also shown in datasheet view on the same form without a subform.



What i'm trying to do is get this split form but in a subform but it doesn't seem to work Only reason is that I don't like having a datasheet subform because they're always slightly out on sizing and have different backgrounds and various annoyances.

Thanks

 

[Simon_MT]

If you don't like the subforms try putting the parent information in the Form Header and subform information into the Form Detail. This may not solve your problem but it is a way of eliminating subforms.

Simon

 

[agehoops]

Does that work though if the form is still only based on 1 table? Won't I start getting problems with data input by trying to source the information from two tables? I had a problem like that before?

 

[RuralGuy]

I'm sorry but I do not have ac2007 so I doubt I can help in this thread.

 

[agehoops]

That's alright no worries. I'm not sure if it can even be done seeing as it won't do it automatically with all the settings correct, but thanks anyway

 

[Simon_MT]

Its a matter of Dependencies. If you need to input both the Parent and then Child then there will be problems, then a subform solution is the answer. However it the Parent record exists you could use the Form Header.

Alternatively you may be able could treat your subform as a Continuous Form which gives you more formatting control.

Simon

 

[agehoops]

Well the way it is structured is that I've got a table storing different banks, linked to a table storing the bank accounts for those banks, and a table linked to that storing transactions for each of those bank accounts.

I want the form to show all of the transactions for that bank account (so the account is already created)

 

[st000000]

Apparently this feature is not available in Access 2007 yet. Several users have submitted feature requests for this to appear in a future version, so keep your fingers crossed until then.