Opening record details in a form from a datasheet

[Access_Novice123]

Hello,

I'm trying to set up my datasheet so that when I click on the ID number, my details form pops up and I can see and edit the record details. This worked for a brief moment using a macro but now it seems to have stopped working and doesn't seem to be able to locate the form.
My datasheet with the information is called formRecordsList
The Form i'm trying to get it to open in is called Record Details

I was using this expression ID!Forms![formRecordsList]!ID which worked for awhile but now asks me to enter the parameters. I tried converting this to VBA but I got a whole host of other error messages popping up one after the other.



Any suggestions? Thank you!!

[ranman256]

Docmd.openform frmDetail,,"[id]=" & me.txtID

[June7]

Missing a comma and form name in quotes. Use txtID if that is the name of textbox or use field name.

DoCmd.OpenForm "Record Details", , , "[ID]=" & Me!ID

[Access_Novice123]

hi there,

Thanks for the responses. I managed to make it work with a Macro to open the form but now my issue is that the macro doesn't want to work if I have the databse forms displayed in a Navigation Form. They work in the stand-alone databse form (formRecordsList) but not when i want it displayed in a Navigation form. It currently just opens the detailed record of the last record opened from the stand-alone form.

Is there a way to resolve this?

Thanks again

[June7]

I don't like and don't use navigation form.

Have to reference the control by referencing through the navigation form. Review https://www.accessforums.net/forms/t...orm-32053.html

[Access_Novice123]

Hi June7, Thanks so much. That does seem to be the issue. Can't quite seem to get the syntax right so if someone else could help me out, i'd be grateful! I'll keep hunting in the meantime!

Thanks!

[June7]

If you want to provide db for analysis and testing, follow instructions at bottom of my post.

[Access_Novice123]

Hi - thanks for the replies so far.

I played with the file some more today and I found that I'm still having trouble with some things that I would love help with!

1. I want to be able to execute some actions within the Navigation Form but i'm having trouble writing the syntax for it. I'd love to be able to open the record details for each entry on both the Open Cases and Closed Cases datasheet
   sheets within the Navigation Form. As mentioned above, they work on the stand alone datasheet form but not within the Navigation Form.
2. Within the Navigation Form (again) I would love for the Add New Record button on the New Case Form to switch tabs to the formRecordsList tab onclick. This action makes a new entry and it would be great to have it switch display to FormRecordsList in the datasheet automatically.
3. I would like to know whether, as designed, the database could handle multiple users entering new records "simultaneously" or whether only one instance of the file can be edited at one time
4. Lastly, how hard will it be to export the Record Detail (New Case) form like this to Word, or online, so that people can enter data there and have it populate the database (I suppose that this ties in to #3, above).

I zipped and uploaded the file, as requested.Tracking Database_nonweb - Copy.zip

Thanks so much for all of the help.


Happy Friday!


Amy

[June7]

1. The Record Details form is already open on the navigation form. Do you mean you want to go to the record selected? This is an unusual arrangement - all forms are bound to the same dataset.

2. Not finding a way to do this - GoToControl does not work, don't see SetFocus method

3. I do have one all-in-one db that has multiple users. There is usually only one user at a time but we tested simultaneous users and it worked. Multi-user database should be split - as the chances for corruption are higher in an all-in-one.

4. Cannot export form object to Word. Collect Data feature allows data collection via emails in Outlook.

All of this would be so easy with normal forms. Are you building a web database?

[Access_Novice123]

Hi there,

Thanks so much for taking a look at this! In answer to your questions:
1. Yes sorry for the confusion, I meant that I wanted to go to the record selected by clicking on the ID field. The way that there is a pop up of the record information in the datasheets. I think that the information is bound to the same dataset because they are all the same records but when the last tick box (DB updated) is checked, the record then becomes closed so I filtered them to the the Closed Cases datasheet. If there is a better way to do this I'd be open to hearing it!

2. That's ok, it was just an ideal- it's not necessary but thank you for trying

3. I'm not sure what it means to "split" the database but if it seems usable as is then that's ok. There are only a potential of about 3 users at one time (maximum) so I don't forsee this being a huge issue..

4. Exporting to Outlook is just fine. I'm not currently building a web database because I couldn't make some of the functions work in a web-based file (the auto fill dates primarily). I'm not sure if I need to be building a web database or not. We do not have sharepoint or anything at my company so it likely wouldn't be used in that way.

Thanks again so much for all the help! Hope you had a nice weekend

[June7]

Did you review the link I posted?

The issue with one navigation subform referencing another navigation subform (both on the same main form) is that they are not both available at the same time. I don't know if what you want can be done with navigation form. It can be done with a normal form.

[Access_Novice123]

Hmm sorry I don't see a link! maybe i'm blind haha

[June7]

In post # 5.