Data on the tab conctol do not show up

[Frank Situmorang]

Hello,

I tried to make like the address sample of data base using tabcontrol to
show up the data of my church membership. I prefer that way because all the
data can not accomodate in one form, so I put it:

1. General information
2. Membership accepted, and how
3. Membership transferred and how

I put them on three pages of the tab control and the tabcontrol is put on
the detail of a form. In the form property data source is from a query that
I already made.

But when I tried to view the from there the data does not show up. Can
anyone help me? waht should I do. Is there any event procedure that we should
make?

When we click each tab does it always showup for the same record at a time?

Thanks in advance

 

[Steve Schapel]

Frank,

From your description, I would expect it to work as you want. I would
expect the form to show one record from the query, and that moving from
one page to another on the tab control would show the additional data
for the same record.

You mentioned the "data source" property of the form. I trust you mean
the Record Source property, is this right?

If you open the query separately, do you see the records you expect in
the query datasheet?

If you look again at the form properties, what is the setting of the
Data Entry property (it should be No)?

 

[Frank Situmorang]

Yes Steve...dta entry is no, and what you said is correct that is what I
expeceted, but after reading your answer I tried to open my query separately
I could not see the data on it, I do not know why. You know my query consitst
of many table linking and some table already cotains data, I wonder why my
query is no data while the link is ok if I see on the grid query.

Do you think because it is becaue some table is empty, but the main table
member is already filled and it linked to gender table, but think it would
have no problem if the foregin key is not a required, becasue I want to fill
it later

Frank

 

[Rick Brandt]

Yes Steve...dta entry is no, and what you said is correct that is
what I expeceted, but after reading your answer I tried to open my
query separately I could not see the data on it, I do not know why.
You know my query consitst of many table linking and some table
already cotains data, I wonder why my query is no data while the link
is ok if I see on the grid query.

Do you think because it is becaue some table is empty, but the main
table member is already filled and it linked to gender table, but
think it would have no problem if the foregin key is not a required,
becasue I want to fill it later

If you are using standard joins between all of the tables (no arrow head on
either end) then you will only get result rows where the tables on both sides of
the join contain matching records.

Double-click a join line and look at the three choices you are given for join
types. Changing some or all of those might give you the results you want.

 

[Linq Adams via AccessMonster.com]

You probably also need to review how you have your data divided; having a
separate table for gender is really, IMHO, an overkill, and makes me wonder
if your many tables are all necessary.

Tabbed pages for this type of situation, where screen "real estate" is at a
premium, is an excellent choice!