Open record from data sheet view ?????

[WILYWAYNE11]

I have been exploring a way to open a specific record in form view with a command from the data sheet view! This could be a time savings for our business. I have looked at creating a data macro but that doesn't seem to work either. Any suggestions? (PS..we are NOT engineers). Attached is a test database that we are experimenting with. I saw this same "feature" in a Access template database on line and it would be helpful if we could use it our large database as well

 

[Gasman]

Use OpenArgs argument on open form and pass in the ID of that record, or filter to just that record.
See DoCmd.OpenForm command

Why not inspect that DB and see which way they did it?

 

[bastanu]

Usually to navigate to a certain record from a datasheet it is customary to use the double-click event of a id or (customer, product, etc.) name field.

Cheers,

 

[theDBguy]

Hi. Can't look at your file right now but maybe take a look at the new Northwind 2.0 template for ideas on how they do something like this.

Sent from phone...

 

[lacampeona]

Hi
If I understand correctly i make some changes in your database.
I create for you new form in datasheet view. Then from this form you can open any ID record in form view.

See if this is what you need.
Best regards

 

[lacampeona]

Hi Pat
yes I also wanted to mentione that our new user Wily has to change all the namings in tables. I already change the id name.

About the subform I think we make that correct ?
From form in datasheet view users will click specific id (conpany id) and then in tab job records in the form- they will see see all the jobs created for that company iD?

​

​

 

[lacampeona]

Hi Pat
yes first time i was faster than you.

if i understand correctly what user want to do is...:
he have main form ..here he create id number company

and then inside he has a subform to create job records.,, I think is not redundand.

 

[isladogs]

You can't have command buttons on a datasheet form.
However there is a trick you can do to achieve this using a split form which has a single form section together with a datasheet.
You can hide the single form section leaving just the datasheet & have a command button in the form header. For example

This idea is also used in the new Northwind 2.0 example databases