Extracting a record from a Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2000 and I am new to the use of sub forms. I have a sub
form in datasheet view of my main form. I had this "brilliant" idea to
display another form with detailed data of a row based on the value of one of
the cells. By double clicking on the value of a cell, which contains a
Site_ID, I want to use this Site_ID value as a variable in the query of this
detailed form. I'm having trouble finding this procedure in my Access 2000
manual. CAN ANYONE HELP!?!?!?!?
 
To get the value of one of the fields in a subform write

Forms![mainFormName]![SubFormName].Form![FieldName]
 
Ofer,
My subform returns many rows. I am looking to point my new form to one of
these rows. Can this code be pointed to a specific row I double click on?

Ofer said:
To get the value of one of the fields in a subform write

Forms![mainFormName]![SubFormName].Form![FieldName]

AGF said:
I am using Access 2000 and I am new to the use of sub forms. I have a sub
form in datasheet view of my main form. I had this "brilliant" idea to
display another form with detailed data of a row based on the value of one of
the cells. By double clicking on the value of a cell, which contains a
Site_ID, I want to use this Site_ID value as a variable in the query of this
detailed form. I'm having trouble finding this procedure in my Access 2000
manual. CAN ANYONE HELP!?!?!?!?
Click to expand...
Click to expand...
 
The Forms![mainFormName]![SubFormName].Form![FieldName]
returns the value of the field with the records that got the focus in the
subform.

So if you press on the third record it will return the value of the field
name from that record

AGF said:
Ofer,
My subform returns many rows. I am looking to point my new form to one of
these rows. Can this code be pointed to a specific row I double click on?

Ofer said:
To get the value of one of the fields in a subform write

Forms![mainFormName]![SubFormName].Form![FieldName]

AGF said:
I am using Access 2000 and I am new to the use of sub forms. I have a sub
form in datasheet view of my main form. I had this "brilliant" idea to
display another form with detailed data of a row based on the value of one of
the cells. By double clicking on the value of a cell, which contains a
Site_ID, I want to use this Site_ID value as a variable in the query of this
detailed form. I'm having trouble finding this procedure in my Access 2000
manual. CAN ANYONE HELP!?!?!?!?
Click to expand...
Click to expand...
Click to expand...
 
Ofer,
Thanks for the help! I understyand now and it is working!

Ofer said:
The Forms![mainFormName]![SubFormName].Form![FieldName]
returns the value of the field with the records that got the focus in the
subform.

So if you press on the third record it will return the value of the field
name from that record

AGF said:
Ofer,
My subform returns many rows. I am looking to point my new form to one of
these rows. Can this code be pointed to a specific row I double click on?

Ofer said:
To get the value of one of the fields in a subform write

Forms![mainFormName]![SubFormName].Form![FieldName]

:

I am using Access 2000 and I am new to the use of sub forms. I have a sub
form in datasheet view of my main form. I had this "brilliant" idea to
display another form with detailed data of a row based on the value of one of
the cells. By double clicking on the value of a cell, which contains a
Site_ID, I want to use this Site_ID value as a variable in the query of this
detailed form. I'm having trouble finding this procedure in my Access 2000
manual. CAN ANYONE HELP!?!?!?!?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top