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

yeng · Jan 22, 2020

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.

theDBguy · Jan 22, 2020

Hi. I haven't looked at your db yet but just wondering if you have tried/considered using a Split Form?

yeng · Jan 23, 2020

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.

Gasman · Jan 23, 2020

Try the Emulated Split form?

theDBguy · Jan 23, 2020

yeng said:
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.

theDBguy · Jan 23, 2020

Gasman said:
Try the Emulated Split form?

Ooh, I was looking for that but couldn't find it, so I ended up downloading the attachment instead. Thanks!

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

yeng

New member

Attachments

theDBguy

I’m here to help

yeng

New member

Gasman

Enthusiastic Amateur

theDBguy

I’m here to help

Attachments

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread