Using query in form?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JerkerPihl - 12 Sep 2006 15:32 GMT

I have a table with a lot of columns. I have two columns i want to prepair to
be used in a tablesheet form. One with sizenumber and another with
productnumber. I have a datasheet form where I want to use the data from
sizenumber and productnumber writen as one ex. "3-345767" (first number is
size and the second is productnumber). Well I succesfully done this in a
query table but I can't get it to work or sort in the form. Its greyed out.
Any suggestion? Can I do this on another way?
I gonna get greyhaired of this..
ANY suggestions would be help full!

Reply to this Message

Klatuu - 12 Sep 2006 16:54 GMT

You had to do the combining of the forms in a Calculated field in your query,
no doubt. The problem is, you can't update a calculated field in a recordset.

> I have a table with a lot of columns. I have two columns i want to prepair to
> be used in a tablesheet form. One with sizenumber and another with
[quoted text clipped - 5 lines]
> I gonna get greyhaired of this..
> ANY suggestions would be help full!

Reply to this Message

JerkerPihl - 12 Sep 2006 16:59 GMT

Well that is not a problem. It just for viewing the products.

> You had to do the combining of the forms in a Calculated field in your query,
> no doubt. The problem is, you can't update a calculated field in a recordset.
[quoted text clipped - 8 lines]
> > I gonna get greyhaired of this..
> > ANY suggestions would be help full!

Reply to this Message