higene said:
I want to have my data in a table to display on 2 tabs when i design
a form. Like tab one would have general info and tab 2 would have
specific info from my data table?
I can't the information in my table to appear split between 2 tabs.
Can it be done using the forms wizard or only from create form in
design view./ I need step by step help.
Thanks
Are you talking about data from two tables with a relationship or is all the
data in one table?
If one table all you have to do is place a TabControl on the form and place some
of the controls on each page. Forget the wizard (they just hold you back
anyway). Open a new blank form and set its RecordSource property to your table
name. Then drag a TabControl onto the form from the Toolbox.
Now, display the field list from the Form-Design toolbar. It will list every
field in your table. One by one (or in groups) you can drag and drop them onto
the desired TabPage. Just make sure the desired page is "on top" and when you
drag the field over it the back-color of the page will change to black
indicating you are positioned "within" the page, then drop them.
An important note is that only *new* controls can be drag n' dropped onto
TabPages. Existing controls must be cut to the clipboard, then the page is
selected and the control pasted onto it.
If you are talking about two tables then you need a form with a subform for the
details and you simply place the subform on one of the TabPages.