Using query in form?

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

Guest

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!
 
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.
 
Back
Top