Home | Microsoft | Office Access 2003 (077-02871) for PC | My opening screen is lin...
Microsoft Office Access 2003  for PC
Problem for Microsoft Office Access 2003 (077-02871) for PC

My opening screen is linked to main table in db. I




By ellen1460 on Jul 04, 2009

" "
My opening screen is linked to main table in db. I have set each field to locked so users won't edit in error. I added an "Add, Delete or Edit" button to open an almost identical screen that can be edited. Both are bound to the same table. When the second form opens, no records show up, but the user can add a new record. I want it fully populated so the form can be used to edit existing records. I assumed that the problem was the other open form, so I added a macro that first closes the original form, then opens the editable version. Still no records. I can open it directly from the list of forms and it populates correctly. Data Entry is set to No and Recordset type is set to Dynaset. How to fix? Thanks
Comments:

Jul 05, 2009

- I finally figured it out myself--the second form was set up as "dialog" rather than normal in the macro.

Solution #1

posted on Aug 10, 2009
Not Rated)

kagitapus

Rank: Master 
Rating: 84%, 15 votes
Change the "Data entry" Property to "No". This is what preventing you in viewing other records.
Was this helpful?
Yes
No

Popular Solutions for Microsoft Office Access 2003


Questions and Unsolved Problems for Microsoft Office Access 2003


Do you recommend Microsoft Office Access 2003 (077-02871) for PC?
Answer

Answer
Hey everyone. Can anyone help me come up with a script that will allow me to import a text file... (More)

Answer
I am getting the message "Module not found" after deleting a form that I no longer use... (More)


Didn't find what you were looking for?

Describe your problem:

Select a Category:





Sponsored Links



Ask our Experts

 

Solve Your Problem Now!
Chat Live with an Expert
Chat Now
Browse popular Problems
More Common Problems
Most Common Problems for:
For Microsoft Office Access 2003 ...:

Top Business and Pro... Experts

Rank: Guru Guru  

Solutions: 437
Member Since: October 2009

Experience: Experienced a lot in computer troubleshooting. Knowledgeable about cellular phones.

Ask Me
Find more Business and Pro... Experts

Top Computer & Laptop Repair

(513) 874-3306
We fix and repair laptop motherboard no video, no...
LaptopOnCall Inc.

(952) 890-7770
Zkarlo.com provides discount and used laptop parts...
Zkarlo.com


       
Solve Your Problem Now!
Chat Live with an Expert
Chat Now

X
Continue
When the original poster rates a solution that was given to his own problem, that rating is locked!
X

Are you sure the solution content is Inappropriate?
   
Tech buddies can communicate directly to answer questions. Become a Tech Buddy and have direct access to your favorite expert for FREE!
Insert Link
Insert Image
Insert You-Tube clip
Insert List
Insert List
Spell Check

What is this?



Select