Create special autonumber.
anonymous_at_discussions.microsoft.com
Date: 01/24/05
- Next message: Steve Conway: "Re: Create Relationship using VBA"
- Previous message: Jefferey Simmons: "Create special autonumber."
- In reply to: Jefferey Simmons: "Create special autonumber."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 24 Jan 2005 06:35:01 -0800
see your post under forms coding
>-----Original Message-----
>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
>
>
>.
>
- Next message: Steve Conway: "Re: Create Relationship using VBA"
- Previous message: Jefferey Simmons: "Create special autonumber."
- In reply to: Jefferey Simmons: "Create special autonumber."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
