469,167 Members | 1,949 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Help with VB-Macro

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
Jan 24 '12 #1
1 1085
NeoPa
32,167 Expert Mod 16PB
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?
Jan 24 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Dim S | last post: by
2 posts views Thread by serge calderara | last post: by
reply views Thread by Tim | last post: by
reply views Thread by BrianDH | last post: by
5 posts views Thread by Andrew | last post: by
reply views Thread by douglas | last post: by
reply views Thread by sheenitmathew | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.