Update Details on a Form as I cycle the items on the datasheet (1 Viewer)

yeng

New member
Local time
Tomorrow, 06:55
Joined
Nov 15, 2019
Messages
8
Hello,

I'm having a problem on how to update/show the details of an item that I select or is the current item on the datasheet.

I want the data of the machines show as I cycle or select base on the listed items on a datasheet.

The form is inside a Navigation form. The form has 2 subforms. One is a datasheet showing the list of machines. The other subform is in a single form showing the details of the machine.

I have attached here the file.
 

Attachments

  • test.accdb
    608 KB · Views: 77

theDBguy

I’m here to help
Staff member
Local time
Today, 15:55
Joined
Oct 29, 2018
Messages
21,358
Hi. I haven't looked at your db yet but just wondering if you have tried/considered using a Split Form?
 

yeng

New member
Local time
Tomorrow, 06:55
Joined
Nov 15, 2019
Messages
8
Hello Sir,

The split form work if the form is not inside the navigation form. But if it is in the nav. form it wont.

thanks for the advice.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 15:55
Joined
Oct 29, 2018
Messages
21,358
Hello Sir,

The split form work if the form is not inside the navigation form. But if it is in the nav. form it wont.

thanks for the advice.
Hi. Good point. Okay, I looked at your db, and there's an easy fix for that. Take a look at the attached modified version of your db and let us know if this works for you.
 

Attachments

  • test.zip
    42.1 KB · Views: 69

Users who are viewing this thread

Top Bottom