Refreshing a form - Microsoft Access / VBA

6 New Member

I am attempting to create an "easy input (from the pov of the user)" form.

A main form displays one page per record with a sub form displaying a list of records related to the main record. The sub records can be updated manually (in particular -added). I want to add functionality where a user can also update (add) from a lookup. The look up is listing of records, (I am not adding a drop down because of multiple field search requrements) that the user can select from. I have succsesfully managed to get a second form to display search results and append flagged (Yes/No toggle) records to the source (sub) records.

The problem I am facing is that I cannot get the main form with main and related sub records to automatically update / refresh (without the closing and reoppening and then navigating to the required main record).

Can any one offer me advice on what I might be able to do (it's a might/maybe because I am new to this)?

Thanks
Iain

Sep 1 '06 #1

Subscribe Reply

1709

MMcCarthy

14,534

Recognized Expert Moderator MVP

I don't really understand what you're trying to do. If you add or edit a sub record why do you need the parent record to change?

I am attempting to create an "easy input (from the pov of the user)" form.

A main form displays one page per record with a sub form displaying a list of records related to the main record. The sub records can be updated manually (in particular -added). I want to add functionality where a user can also update (add) from a lookup. The look up is listing of records, (I am not adding a drop down because of multiple field search requrements) that the user can select from. I have succsesfully managed to get a second form to display search results and append flagged (Yes/No toggle) records to the source (sub) records.

The problem I am facing is that I cannot get the main form with main and related sub records to automatically update / refresh (without the closing and reoppening and then navigating to the required main record).

Can any one offer me advice on what I might be able to do (it's a might/maybe because I am new to this)?

Thanks
Iain

Sep 1 '06 #2

Similar topics

4985

Dynamically Refreshing a DIV or other control from the Server

by: Philo Del Middleston | last post by:

I've been searching, but apparently not phrasing my search right, so I'm going to float a question out here in the meantime... I'm wondering how to go about refreshing the content of a control...

PHP

392

Form not refreshing after autopostback unless keyboard or mouse mo

by: LRD | last post by:

Form not refreshing after autopostback unless keyboard or mouse move Hi, We created several new ASP.NET C# forms for our intranet. In each form we use panels for different sections of the...

.NET Framework

2648

Remove filter stops form from refreshing

by: Mark Payne | last post by:

Gudday, I have an Access 2000 database which I am using as a phone directory of residents in the hostel where I work. The front end for this directory is a form with a text box (the search name...

Microsoft Access / VBA

2561

Refreshing a Windows Form

by: Robert Clark | last post by:

This a pocket pc/smartphone questions mainly, but i thought i'd ask the question in the C# newsgroup. I have a form which i use to display information from a web service. From this form i open...

C# / C Sharp

2396

Form not refreshing

by: Steve Hoyer | last post by:

Good day. I wrote an application to convert data from one database to another. It runs through about 100,000 records for this conversion. That bit works fine. I have on the form a progress...

Visual Basic .NET

7179

VB.NET Screen Stops Refreshing After Losing Focus??

by: Chris Moore | last post by:

I have a .NET form where I am updating a progress bar & counter. As long as the form never loses focus, everything on the form refreshs fine. But If I open another window (like Windows Explorer)...

Visual Basic .NET

1635

Problem with form refreshing

by: dmartin_1 | last post by:

I'm building an application with Visual Basic 2005. The application is multi threaded. It has a record counter on the form that counts up to completion. It works fine throughout the process as...

Visual Basic .NET

1465

VB 2005: Refreshing Multiple Forms Project

by: sean.hpr | last post by:

Hi all- I am a vb2005 newb so apologies in advance. Essentially I am having some problems with data refreshing on some of my forms. Background: I have created a project containing a few...

Visual Basic .NET

7427

updating combobox without refreshing in JSP page

by: honey99 | last post by:

Hi! I have to fix a problem in JSP.Actually,i have a JSP page say Ex1.jsp.In this Ex1.jsp i have an anchor tag which links into another JSP page i.e when i click on the link another pop-up window...

Javascript

1936

I want the contents of a file to be put in a textbox without refreshing

by: shankari07 | last post by:

hi guys, I have a form in html which has the city drop down. when clicking the drop down a javascript is called and a file(test.txt) is created and the city is written into the file. Through php...

PHP

7115

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7190

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7360

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

4881

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4578

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3086

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3076

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1392

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

633

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP