Re: Displaying fields in a stock table

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Steve. Tried that and everything looks Fine. the problem would appear to
be something quite different (and to me Wierd). I mentioned earlier that I
added a non visible column that was bases on StockID in the Stock Table. The
form (and Query) performs well if I enter any number from 1 to 13 in this
Criterion box. The Form displays all the appropriate information from the
various forms linked to the Query allong with the correct Serial Numbers
stored in the appropriate fild of the Table Stock. However, if I enter any
number over 13 the resultant query(and Form) is Blank.
Thanks for your help RayC

"Steve" wrote:

Create your form using the form wizard and select the query as your record
source. Let us know what you get in the textboxes for Make and Model.

PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx




"Ray C" <RayC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:614A1677-6612-423A-8B98-5979C4740115@xxxxxxxxxxxxxxxx
Hi Steve, I really appreciate your help, thank you.you are right in your
assesment of how my Stock Table looks but the whole thing is somewhat more
complicated than that. However, witha view to trying to undestand what is
happening I created a Query and added the ent_tblModel, ent_tblMake and
the
tblStock to it. I joined the two entry Table ID's to the respective
entries
in the stock Table and I added the Stock Table ID but did not male it
visible
in the query design view. I draged the Make (name) and the Model (name)
into
the query and in the Criterion of the Stock ID, I added a number. Great,
the
Query shows the Make (Name) and the Model Name of the Record that matches
the
number I placed in the Criterion.
So Far so Good. I generated a Form and based the form on the Query but the
text boxes are Blank. The Control Source of the Make and Model Text Boxes
in
the Form are both set to Make and Model in the Query. I must be doing
something wrong, any further thoughts?
RayC


Your Stock table looks something like this:

StockID
MakeID
ModelID
.....
.....

For relationships, you should then have MakeID joined to MakeID in the
Make
table and ModelID joined to ModelID in the Model table.

In your query, include all three tables. Pull down the Make and Model
text
fields from the respective tables. Base your form on this query. Set the
controlsource of one textbox to the Make text field and another textbox
to
the Model text field.

PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx




"Ray C" <RayC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DF1A4B43-E957-4223-9E0E-8060E086339D@xxxxxxxxxxxxxxxx
I have a Stock Table and I have Entry Tables that go with the stock
table.
The Make entry Table contains a Make ID and all the different Makes of
Stock.
Similarly, the Model Table contains a ModelID and all the different
Models. I
use a combo Box to make the selection and ID is the Bound Column so
that
the
Combo displays the Make/Model as Text but the Make/Model ID is stored
in
the
Stock Table. My problem is that when I subsequently use a Text Box to
display
the Make/ Model stored in a particular Record of the Stock Table, all
that
is
displayed in the text box is the ID number. I should be able to get the
Text
Box to display the Make/ Model text that is associated with the ID by
using a
Query but I don't know how to go about that. Could anyone help please?
Thanks RayC






.

Quantcast