form view is blank!

[ace]

I can see my form in design view but when I go to form view it is blank!

Any idea why!

Thanks,
AC Erdal

 

[ace]

Here is some more info;

I actually I am trying to create a subform using tab control. Before
inserting the subform I was able to see the form, but not after the insertion
of subform.

Also, I have the followings;
allow additions, yes
allow edits, yes

Thanks,
AC Erdal

 

[John W. Vinson]

I can see my form in design view but when I go to form view it is blank!

Any idea why!

Thanks,
AC Erdal

This typically happens when both of two conditions apply: the form's
Recordsource returns no records (so you can't see existing records), and it
also is not updateable (so you can't see the blank new record either). What is
the Recordsource? If you open it as a query do you see any rows?

 

[ace]

Here is the record source for the form;

SELECT tblContacts.IDContact, tblTransaction.IDTransaction,
tblProperties.IDProperties FROM tblProjects, tblProperties INNER JOIN
(tblContacts INNER JOIN tblTransaction ON
(tblContacts.IDContact=tblTransaction.IDContactSellerAgent) AND
(tblContacts.IDContact=tblTransaction.IDContactBuyerAgent) AND
(tblContacts.IDContact=tblTransaction.IDContactBuyer) AND
(tblContacts.IDContact=tblTransaction.IDContactSeller)) ON
tblProperties.IDProperties=tblTransaction.IDProperties;

I thouth you need to have these relationships to be able to access to all
these tables through the tab control in this form! I have a tab for
Transaction, Buyer, Seller, BuyerAgent, Seller Agent, and Properties. When I
remove this select statement, I can see the form. It is not blank anymore!
Can you explain what is going on!

A different question. When I click on the, for example, first tab, the page
moves up and fields above the tab cannot be seen unless I scroll up again!
Why the form page is jumping to the tab?

Thanks,
AC Erdal

 

[John W. Vinson]

Here is the record source for the form;

SELECT tblContacts.IDContact, tblTransaction.IDTransaction,
tblProperties.IDProperties FROM tblProjects, tblProperties INNER JOIN
(tblContacts INNER JOIN tblTransaction ON
(tblContacts.IDContact=tblTransaction.IDContactSellerAgent) AND
(tblContacts.IDContact=tblTransaction.IDContactBuyerAgent) AND
(tblContacts.IDContact=tblTransaction.IDContactBuyer) AND
(tblContacts.IDContact=tblTransaction.IDContactSeller)) ON
tblProperties.IDProperties=tblTransaction.IDProperties;

I thouth you need to have these relationships to be able to access to all
these tables through the tab control in this form! I have a tab for
Transaction, Buyer, Seller, BuyerAgent, Seller Agent, and Properties. When I
remove this select statement, I can see the form. It is not blank anymore!
Can you explain what is going on!

You're mixing all sorts of different things together. A Tab Control does
*ABSOLUTELY NOTHING* to the logical structure of your data! It's nothing but a
tool to let you share screen space more efficiently; you can put one set of
controls on one tab page, and another set on another page just to save space.
As far as the program is concerned they're all on the same form. Just because
you name or caption a page "ContactBuyer" does *not* affect what fields or
tables are involved.

Since you have a bunch of one to many relationships between tblContacts and
these four other tables, your six-table inner join query will return no
records unless *all six* tables have matching field values, and it will almost
certainly not be editable. Hence as noted previously, it will be blank. This
is one of many reasons that it is not typical (or necessary for that matter!)
to create One Grand Master Query as the basis for a form.

To see data from the related tables on your form, I'd suggest using Subforms.
It's not clear to me how the tables are related nor what they contain so I'm
not sure just what you want, but - *GUESSING HERE* - if you want to see the
Contact Seller Agent's name from the Contact table for a given ID field in the
Transaction table, then I'd suggest using a Combo Box bound to
IDContactSellerAgent, but based on tblContacts and displaying the name:

SELECT IDContact, LastName & ", " & FirstName As Fullname FROM tblContacts
ORDER BY LastName, FirstName;

You could use this as the rowsource query of a combo box bound to
IDContactSellerAgent; the user would then see the agent's name (in the form
"Alvarez, Marcia") or be able to select an agent from the list, while the
computer would see the numeric ID.

A different question. When I click on the, for example, first tab, the page
moves up and fields above the tab cannot be seen unless I scroll up again!
Why the form page is jumping to the tab?

The controls don't fit onto the tab page. Expand the tab control or squeeze
the controls closer.

 

[ace]

John,
I did submit a reply, and it is not in the system again! This happened
before with you for a different problem! I am not sure how is it possible
that my replies are being deleted from the system?

First, I would like to understand what you mean by "combo box bound to
IDContactSellerAgent" Please explain how one could bound combo box!

I have further question but lets clarify this point.

Thanks,
AC Erdal

 

[John W. Vinson]

John,
I did submit a reply, and it is not in the system again! This happened
before with you for a different problem! I am not sure how is it possible
that my replies are being deleted from the system?

You're using the Microsoft webpage, right? It is NOTORIOUSLY buggy: bogus
error messages saying that a message could not be posted when it was, lost
messages, etc. Only a few of the regular answerers (MVP's and others) use the
webpage; I use Agent as a newsreader linked to the news server
msnews.microsoft.com. I can't guarantee that the posts make it to the webpage
but they *do* make it to the newsgroup.

First, I would like to understand what you mean by "combo box bound to
IDContactSellerAgent" Please explain how one could bound combo box!

A combo box GETS data from a Query or a List of Values - its Rowsource; it
optionally STORES one field (its Bound Column) into a field in the form's
recordsource query. This field is its Control Source property.

If a combo box has a Control Source it is called "Bound" (to that field). If
its Control Source is blank it's "Unbound". Both kinds of combos have their
uses; a bound combo is used for selecting a value (usually a foreign key to a
lookup table) and storing it into a table; an unbound combo is often used to
select a record for viewing.

 

[ace]

John,

The problem is relate to following:

A different question. When I click on the, for example, first tab, the page
moves up and fields above the tab cannot be seen unless I scroll up again!
Why the form page is jumping to the tab?

YOU WROTE: The controls don't fit onto the tab page. Expand the tab control
or squeeze the controls closer.

I have tried everythink I know possible to work around this problem but
still the page is jumping up when I click on the tab such that form shows the
tabs and anything below. There are two comboxes above the tabs that you
cannot see anymore unless you scroll up!

Perhaps you can explain little more! When you are talking about the
controls, I presume you are referring the ones in the tab! If that is the
case controls are fitting into the tab page. Is there anything else that I
can check?

Thanks,
AC Erdal

 

[John W. Vinson]

John,

The problem is relate to following:



YOU WROTE: The controls don't fit onto the tab page. Expand the tab control
or squeeze the controls closer.

I have tried everythink I know possible to work around this problem but
still the page is jumping up when I click on the tab such that form shows the
tabs and anything below. There are two comboxes above the tabs that you
cannot see anymore unless you scroll up!

Perhaps you can explain little more! When you are talking about the
controls, I presume you are referring the ones in the tab! If that is the
case controls are fitting into the tab page. Is there anything else that I
can check?

I've often had this happen when there is a Subform control on the tab page.
Even if the textboxes and other controls on the subform fit, if the "box"
around the subform is too big you'll get this jumping behavior.

I don't know how you've got the page laid out so it's hard to be sure. Perhaps
you could save the form as text and email it to me to check: type ctrl-G to
open the VBA editor and the Immediate window, and in the Immedidate window
type

Application.SaveAsText acDataForm, "NameOfYourForm", "C:\My
Documents\NameOfYourForm.txt"

all on one line. This will create a file named NameOfYourForm.txt in your My
Documents folder. You can email it to me as an attachment at jvinson <at>
wysard of info <dot> com (edit out the blanks and the punctuation).