473,324 Members | 2,417 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Forms and Macro Code

Hello All!

Thanks for the help I have very little knowledge of VBA and am learning as I go. Thanks in large part to this website and all of you that are very helpful. I created the macro on my small Access DB and it works but there is one thing that is happening that I am not sure if it is supposed to.

I have two forms ( appraisal form- main form and environmental form - secondary form) with the control source being one table.

Some of my fields are duplicated on my forms for reference purposes and since they are reading off of the same table they auto populate and it works fine.

Hence my issue.

I am running the macro on my [form]![appraisal]![Loan #] and the target field is [forms]![environmental]![loan #1].

The macro does take me to the place I want to go but my target field which was populated is now blank.

Please help? Did I do something wrong?
Nov 16 '07 #1
1 1152
NeoPa
32,556 Expert Mod 16PB
I've created a new thread for this question as it's not related to the other one you posted in ({SOLVED} Go to Selected Record in a another form).

I don't understand what you're asking here so the title is pretty lame I'm afraid. You refer to a macro you run but give no clues as to what it does or what's not working.
Nov 16 '07 #2

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

Similar topics

25
by: Andrew Dalke | last post by:
Here's a proposed Q&A for the FAQ based on a couple recent threads. Appropriate comments appreciated X.Y: Why doesn't Python have macros like in Lisp or Scheme? Before answering that, a...
0
by: Bill | last post by:
I created a very simple DB with several forms and tables in chinese version of Access XP running in Chinese Win XP. Now I try to run the same DB in English version of Access XP running in English...
0
by: Doc | last post by:
Would you enter this in as an "event procedure" or right in the properties of the combo box under event / afterupdate. I kept getting an error message that it could not find the Macro "Me!", when I...
7
by: Kenneth_J | last post by:
Hey everyone, I just started doin some work with access and vba, and don't know much about it yet...any help would be much appreciated. My goal is to create a form in word that can be filled...
3
by: Chris Dunaway | last post by:
A quick scan of the group did not immediately reveal an answer to my questions so here goes. First let me describe my app and then I'll ask the questions. I am writing a Windows Forms App (not...
5
by: Fredrik Melin | last post by:
2005 uses the Partial Class & <form>.Designer.vb for its "windows forms generated code" Anyone know if its faster/better then old 2003 way? Also, when upgrading a 2003 project it did not...
2
by: Jeff | last post by:
I have a database where most of the activity takes place on the demographic forms. There are a few instances where the user will need to navigate to a separate screen, but infrequently. So I set up...
3
by: AFKAFB | last post by:
Hi I've a database where i want a form to open when the db is opened. The code i've written does not call activate the form when the db is opened Option Compare Database Public open_db()
3
by: interuser | last post by:
Hi I want to make an interactive macro that will popup a form with buttons, checkboxes etc. How can I do that? Any examples will be appreciated. Thank you
5
by: pengiliverpool | last post by:
i have designed a userform and everything works ok on my computer. to view the form a macro has been recorded to a button with the code, userform1.show. this macro is called showform(). when...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.