Hi,
I am working on an Access form. The form has a drop down box and an update 
button. The user selects the order number from the drop down box and 
clicks the update button. On Click the following event shud take place.

1. Open the Order table
2. Select all the line items corresponding to the Order number chosen by 
the user from the drop down box.
3. Open another table "temp" which has the updated information for that 
particular Order number  and select all the data records inside.
4. Update the Order table with the records in the temp table.

Due to the business rules i cannot simply delete the old records and add 
new ones at the end of the table. I have to update the exisitng records in 
the Order table.

I am thinking of writing some VBA code. Cud anybody provide me with some 
sample code - I m pretty new to Access and i have to no clue about VBA.

Your help would be greatly appreciated

Thank you
Vivin

Sea B.Lo

-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, August 28, 2002 10:25 AM
To: Access
Subject: [access] RE: VBA for Access


LOL!!

-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...] 
Sent: Wednesday, August 28, 2002 10:17 AM
To: Access
Subject: [access] RE: VBA for Access

houcked awn foniiqs whirct 4 me!

-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, August 28, 2002 10:06 AM
To: Access
Subject: [access] RE: VBA for Access


What's scarier is that I understood your reply!


-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...] 
Sent: Wednesday, August 28, 2002 9:56 AM
To: Access
Subject: [access] VBA for Access

ewe cud yuze ey kweeree dat axepted da oarder digies az a pramter an den dit
da whupdate buhtween da deuce tabels. Dat weigh awl ewe needz iz a mack-row!

I think my keyboard is broken or something!

-----Original Message-----
From: Vivin Deshpande [mailto:vdeshpande@m...]
Sent: Wednesday, August 28, 2002 9:50 AM
To: Access
Subject: [access] VBA for Access


Hi,
I am working on an Access form. The form has a drop down box and an update 
button. The user selects the order number from the drop down box and 
clicks the update button. On Click the following event shud take place.

1. Open the Order table
2. Select all the line items corresponding to the Order number chosen by 
the user from the drop down box.
3. Open another table "temp" which has the updated information for that 
particular Order number  and select all the data records inside.
4. Update the Order table with the records in the temp table.

Due to the business rules i cannot simply delete the old records and add 
new ones at the end of the table. I have to update the exisitng records in 
the Order table.

I am thinking of writing some VBA code. Cud anybody provide me with some 
sample code - I m pretty new to Access and i have to no clue about VBA.

Your help would be greatly appreciated

Thank you
Vivin