Create special autonumber.

  • Thread starter Thread starter Jefferey Simmons
  • Start date Start date
J

Jefferey Simmons

Hi,

I have kinda asked this question already, but let me try it another way. I
create a query that returns one value (record) in one field:

Select Max(field) as Max
From Table
Where x=y

How do I get VB to take the only value from field Max of the query and
insert it into a field in the table underlying my form after I update the
value of another control on that same form? I know how to do the whole
event procedure bit and all the if statements, but how do I get to work with
that stupid value!?

Please help. This should be so simple and it is driving me crazy!

Cheers,

Jefferey
 
Back
Top