open a form based on the record that is selected in current form (1 Viewer)

s_samira_21 · Jun 8, 2011

Hi again

I have a split form named Organization_List that has a field named Details an one other field named ID.
Also I have a form named Organization_Details, too.
I want that when the user click on the details field of a record Organization_Details form opens, so that contains the details of that specific record.
I used the macro in access samples but it does not work. Also I prefer to use VBA code.
Anybody to help me?

jdraw · Jun 8, 2011

Look at the OpenArgs of the OpenForm.
In the On Click event do a OpenForm "Organization_Details" with the ID from the Organizations_List.

http://msdn.microsoft.com/en-us/library/aa160845(v=office.10).aspx

VilaRestal · Jun 8, 2011

OpenArgs is usually a bit too complicated for that. Just adding a where clause to the OpenForm command is enough:

Code:

Private Sub cmdOpenDetail_Click()
[INDENT]DoCmd.OpenForm "frmDetail", , , "recordID = " & Me!recordID
[/INDENT]End Sub

Will suffise in most cases

s_samira_21 · Jun 11, 2011

thank you very much
but unfortunately it doesn't work
I wrote the code but the Organization_Details form opens in a blank record
but something that is funny, is that this code works just for one of the records, that its ID is 14!!!!!

than I used OpenArg, too. but here for each record the form opens only with 14th record's details!!!!!!!!

VilaRestal · Jun 11, 2011

Please post your code here.

I'm guessing either you didn't change the where clause, "recordID = " & Me!recordID
, to the appropriate primary key field for your form ("orgID = " & Me!orgID perhaps)?

Also bear in mind that if the primary key field is a string then it will need to be surrounded in quotes:
"orgID = " & Chr(34) & Me!orgID & Chr(34)

If not that then check Organisation_Details is not set to Data Entry and does Allow Filters.

s_samira_21 · Jun 11, 2011

Private Sub cmd_Details_Click()

DoCmd.OpenForm "Organization_Details", , , "ORGANIZATION_ID_ = " & Me!ORGANIZATION_ID_

End Sub

s_samira_21 · Jun 11, 2011

How can I check for Data Entry setting or filtering?

VilaRestal · Jun 11, 2011

Open the Organization_Details form in design view and check the Properties of the form > Data Tab > Data Entry (needs to be No) and Allow Filters (needs to be Yes) properties.

Having a field end in an underscore is strange. Is that a typo?
And like I said, can we just confirm it is a number field not a text field. (if it's text you'd need to put quotes round it:
DoCmd.OpenForm "Organization_Details", , , "ORGANIZATION_ID_ = " & Chr(34) & Me!ORGANIZATION_ID_ & Chr(34)
)

Also, just check that ORGANIZATION_ID_ is the primary key and is included in the record source of both forms.

VilaRestal · Jun 11, 2011

s_samira_21 said:
than I used OpenArg, too. but here for each record the form opens only with 14th record's details!!!!!!!!

Don't use both.
OpenArgs will be more complicated (you'd have to check for the OpenArgs and filter according to it in code in the Organization_Details on Load event)

It sounds like there might be a filter there already.
Check the Server Filter property of the Organization_Details form is empty (and delete it if it isn't)

One very annoying 'feature' of Access is if a form bugs out while a filter is applied to it and you fix the bug and save it and click 'play' it applies whatever filter there was as a Server Filter on the form (the form will always have that filter). You have to watch out for that.

s_samira_21 · Jun 11, 2011

i dont use both of the ways together....

there is no filter!!!
I don't know whats the problem

VilaRestal · Jun 11, 2011

s_samira_21 said:
Private Sub cmd_Details_Click()

DoCmd.OpenForm "Organization_Details", , , "ORGANIZATION_ID_ = " & Me!ORGANIZATION_ID_

End Sub

Are you sure the field is called ORGANIZATION_ID_?

In the original post you said the field is called ID

If so then the line would be

DoCmd.OpenForm "Organization_Details", , , "ID = " & Me!ID

As to why it's always opening Organisation_Details at the 14th record:
Does it do that when you open the form 'manually'?
It can only be for these possible reasons:

The '14th' record is actually the first record in the table
There is a filter either in the form's properties or in the form's record source
There is some code in the Forms Load or Current event that's telling it to either filter itself or goto that record.

VilaRestal · Jun 11, 2011

I've made a demo database of how this system should work.

You can compare yours to it.

There are two versions of the Open Detail button.
The sophisticated one tries to save the record if it's new and opens the detail as a dialogue and then requeries the list to show any changes made in the detail.

s_samira_21 · Jun 11, 2011

no no no

(
no filter
no extra code
14th is not the first record

when i click on details of each record an empty Organization_details form opens. but when i click on details of the record that its Id is 14, form opens with correct details!!!

the code only works for that record!!!

(

VilaRestal · Jun 11, 2011

Are the other record ID's equivalent (e.g.1,2,3,5,9 etc)?

Perhaps you could create a blank database, import the table and the two forms and post that here so I can have a look.

As per the demo I posted it should be simple and completely reliable to do.

There must be something strange going on.

s_samira_21 · Jun 11, 2011

the data that I entered is in Persian. I don't know if you can understand it or not...

VilaRestal · Jun 11, 2011

The data could be in martian, it shouldn't make any difference unless there's non-roman letters or non-arabic numerals in the ID field, which there shouldn't be

s_samira_21 · Jun 11, 2011

my posts are less than ten so i cant send you the link

s_samira_21 · Jun 11, 2011

it was the 9th one

s_samira_21 · Jun 11, 2011

OK it is 10th
I turned it to English
https://rapidshare.com/files/2607730949/Organizations.accdb
thank you so much...

VilaRestal · Jun 11, 2011

OK I'm downloading it now.
I should say if there's anybody's personal information in the database then you should edit your post and remove the link. (To be honest databases with that sort of information shouldn't be uploaded, we should work on copies with demo data)

open a form based on the record that is selected in current form (1 Viewer)

Registered User.

Super Moderator

';drop database master;--

Registered User.

';drop database master;--

Registered User.

Registered User.

';drop database master;--

';drop database master;--

Registered User.

';drop database master;--

';drop database master;--

Attachments

Registered User.

';drop database master;--

Registered User.

';drop database master;--

Registered User.

Registered User.

Registered User.

';drop database master;--

Similar threads

Users who are viewing this thread