How to Load tables in Tab Control?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a problem.
i have created 3 tables. table A, B and C.
i want to perform data entry on forms, using the tab control function, with
different pages. Each page within the tab control is for a particular table.
For instance, page 1 is for table A. page 2 for table B and so on.
my problem is that i don't know how to call up these tables when i click on
a particular page.
can anyone help to give me a clue?
thanks
 
Create three forms for entering data into the tables; one form for each
table. Make the size of the form so it fits on a page on your tabcontrol.
Put a subform control on each page. You don't need to set the Link
Master/Link Child properties. Set the Source Object property of each subform
control to one of the three forms. When you enter data into any page of the
tabcontrol, the data will be automatically saved to the table that subform
is bound to.
 
The answer seems to be: make a subform for each table. First make a form
for each table, then create another 4th form and, using the subform tool in
the toolbox, make 3 subforms inside this, but leave the master/link child
properties blank, since it seems the 3 tables aren't related, according to
your description.
 
Yes, that is correct. A subform is placed on each page of the tab control.

Steve
PC Datasheet
 
thanks all for the valuable feedback.
i m trying out the method.
at the same time, i need a bit more advise on the following.
my 3 tables have one column known as topicID which is similiar to all 3
tables. In this case, do I link the master/child properties? where do i link
them? if i did not do it when i first created the form, how can i do it now?

another question....
i wish to select a picture to go with each question. i "studied" the
northwind example. however, i got problem with adding/delete picture. is
there any where i can learn the step by step way to do it?
i would like my picture to resize to fit into the image frame. what should i
do to go about it?
pls help and thansk alot :)
 
Back
Top