Help with VB-Macro

[mjwilson0675]

I will be the first to admidt.. I'm a Access-VB Id10t.
Now that we have that covered, this is what I'm trying to do...

In a form I have 2 fields INPUT & LOCVAR, these fields are not attached to any table.

I need a select and update macro that will do the following
After Update of INPUT execute
FIND 'FORM-INPUT' from TapeInfoTable\BarcodeColumm
IF 'FORM-INPUT' is equal to BarcodeColumm
then UPDATE LOCATIONColumn to equal FORM-LOCVAR
also UPDATE TIMEColumn to Now()
After complete, return to form and clear INPUT field for new entry

Any and all help will be appreciated... hopefully that makes sence enough to someone on this llist

Mike

[NeoPa]

What I think you need is a form that maintains the [TapeInfoTable] with an unbound control (TextBox or ComboBox) that enables you to filter the record to update. At that point you can update the [Location] field via its (bound) control on the form. An AfterUpdate of that control could trigger code to set the current time value in the control for [Time]. Use the wizards to help you design the original form and Example Filtering on a Form to help on the filtering side.

Does that all make sense?