Looping Through Form

[durdle]

Good day Everyone,

I was seeking some advice with regards to data on my attached form. Essentially my form is build on a query which can return multiple records on the form. By each record you will see an Update, Delete or Cancel button. I am tring to build the SQL and/or queries for these command buttons but I am not sure how access is going to handle my request. For example if I click the "Delete" button for record #2 , how will access know I am referring to the second record and not say the first. I am tring to figure out how to narrow my code down just to include the record parallel to the command button. It will come clearer if you dl the db.

thanks

durdle
________
buy roor bongs

 

[dcx693]

It should not be a problem. As you click on a command button, the record holding that command button becomes the current record. You can verify this by looking at the record selector triangle to the left side of the record. Test this out just to convince yourself. Place some code like: MsgBox Me.empid in the click events of the buttons just to be certain it's selecting the proper record.

 

[durdle]

True enough dcx693,

I didn't think of that.

Thanks
________
buy silver surfer vaporizer