Updating fields in table instead of numbers (1 Viewer)

[santhosh23]

Hi ..I have a form [Form1] which is used to assign work based on Project, Activity , Resource and Machine. This value gets recorded in a table [tblRecord] which has the fields ProjectBC, ActivityBC,MachineBC,ResourceBC.. All these fields stores value from form1 as a 13 digit number [123456789011 ]. I want all these to be displayed in corresponding names.

Rightnow I am using a Update query to change the barcode values to corresponding names like..
ActivityBC - [tblActivity].[ActivityList]
MachineBC -[tblMachine].[MachineName] and so on ..

Can anyone help me with using After Update function in the table and using macro within a table to automatically update the values instead of running the queries

anyhelp is appreciated.

 

[Ranman256]

thats what access is all about, using queries.
why dont you want to use them? they are the life blood of Access.

field_afterupdate()
docmd.setwarnings false
docmd.openquery "quFixFields"

but in a form bound to table, you can manually modify fields
[field1] = 2 * 4

 

[santhosh23]

@Ranman256 ..Thanks for the response..I thought using macro inside table will be more simple and reduces work. Can you explain how to use this code you entered..