View Full Version : Copying the result of a query to a field


ElCabron
03-18-2002, 11:57 AM
Hi,
I'd like to know how to copy the result of a query (by pressing a button) to a field in my form.

- I already have a query that return a single value
- I have a button that calls my query (but it displays the result in a window instead of copying it in my field)

Any ideas? Thanks!

Sebastien

Fuga
03-18-2002, 01:42 PM
Use an update or append query to fill in the field in your table. (Depending on if you wish to update a field on an existing post, or add a new post.)

Fuga.

[This message has been edited by Fuga (edited 03-18-2002).]