Discussion Locked

Moving Information by macro in Access

0 helpful

2 replies

by chezacke May 4, 2005 last reply May 5, 2005

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I was wondering if it is possible to set a macro in microsoft access that will move information from certain fields in one form to certain fields in another form to remove the need to re-enter data in the second form.

2 replies

by j.lupo May 5, 2005

I know it is possible as some of our Access DB apps do just that. Unfortunately, I don't have too much access to the macros. In the macro screen design view, one of the dropdowns is for copy object. You can use this to copy from one form screen element to another if I remember correctly.

Try the following link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/acactCopyObject_HV01122133.asp

by dryflies May 5, 2005

you absolutely can do that using the setvalue command but it might be easier if you used a query to map the fields. Also, needing to re-enter data redundantly that way indicates an architectural problem with the database. both forms should be getting that data from the same table.

This discussion is closed to new replies.

2 replies

Trending Web Development posts

What Makes a Business Website Effective in 2026

What should I look for when choosing a vertical drama app development company

Windows and macOS computers becoming slow or unstable after updates - what should I check first

Optimizing WordPress widgets and DOM size

Best Ways to Improve Website Visibility