changing a field in another table

[miss_sunshine]

I want a macro to change the value of a field in another table - its a combo box stating "available" and "unavailable". I would like to change these values automatically, based on what I enter in another form.

I have tried using SetValue, but it does not seem to work without error.

 

[Mile-O]

Use an UPDATE Query; not a macro.

 

[miss_sunshine]

Use an UPDATE Query; not a macro.

I have tried this too, but for some reason it seems to create a new record in the table, instead of changing a specific one. Any ideas why this is happening? Cheers

 

[maxmangion]

you should explain how did you try to work it out with the Update Query, maybe someone can help with that rather than trying to find a 'work around' with macros.

 

[reclusivemonkey]

I have tried this too, but for some reason it seems to create a new record in the table, instead of changing a specific one. Any ideas why this is happening? Cheers

Are you sure you didn't create an APPEND query?