Topics Search

Continuous Form Select Record

Continuous Form Select Record
Views: 99
Am having a problem that I can't seem to work out.

I have a continous form that displays records based on the output of a query. I want to have a button by each record that once clicked opens up the full record in a new form.

I have looked on the web and most people say use the button wizard. When I do this it cannot seem to find any records on the first form to select to match with the second form (record ID). They are both bound to the same query
Sponsored Links:

More topics

 

Multiple Record Selection on a Continuous Form

Preview
Is it possible to use the record selectors on a continuous form to do anything useful? I have a continuous form as a subform which displays a list of customer contracts and some related data and it would be nice if I could select multiple records and print them.

However, I have noticed that although you can select multiple records, as soon as you press a command button the selection changes to a single record.

Is this fixed behaviour, or does anyone know if it can be altered
 

No Current Record error - Continuous Form

Preview
I have a main form which has a continuous form (subform) on it. Once field from the selected record in the continuous form sets the SQl statement for another subform. except that sometimes I get a "no current record" error when the main form refreshes.

Could be a bug with the continuous forms? Even though the arrow is on a record, it isn't really selected. Any way to select a record with VBA?
 

Get position of record in continuous form

Preview
I have a continuous form that displays various data. I have a button on the form that opens a popup form, displaying content relevant to the current record in the continuous form. I would like this popup form to appear directly below the current record in the continuous form, if possible. I tried to use .Top property of any of the controls in the continuous form, but the .Top property is 0.

How can I get the screen position of a control for the current record in a continuous form?
 

Get position of record in continuous form

Preview
I have a continuous form that displays various data. I have a button on the form that opens a popup form, displaying content relevant to the current record in the continuous form. I would like this popup form to appear directly below the current record in the continuous form,

I tried to use .Top property of any of the controls in the continuous form, but the.Top property is 0.

How can I get the screen position of a control for the current record in a continuous form?
 

Create a continuous form using data from a table

Preview
I have a table tblcolor which each record contains the different colors, I.e. red, blue, green, etc

I want to create a continuous form where each record is entered by selecting colors from the tblcolor table.

What I would like is that when the continuous form opens the first record shows a dropdown box where one would click on the dropdown and the colors would appear. The user would then select a color and the next record would appear as a dropdown box. When the second record is selected the third record appears, etc….
 

populate word template from a continuous form

Preview
Is there anyway to populate a word template from a continuous form?

Currently, only one record from the continuous form appears in the word template, which is the the record that has the focus.

I'm using this code


.ActiveDocument.Bookmarks("BookmarkOne").Select
.Selection.Text = (CStr(Forms!FormName!FieldName))
 

Updating specific record on continuous form

Preview
I have a continuous form that is populated by a query I created. I would like to add a button in the details sections of the continuous form that would prompt a popup for the user to edit information specific to the record that was selected.

Is there a way to reference the record in which the button pressed?
 

Hiding a new record in a continuous form

Preview
I have a form that contains a subform. The subform is a continuous form. As soon as you enter a value in the continuous form a new record is displayed below the one being entered. Is itpossible to hide the new record from appearing and it only being displayed when a button is selected or enter is pressed on the last field.
 

Hiding a new record in a continuous form

Preview
I have a form that contains a subform. The subform is a continuous form. As soon as you enter a value in the continuous form a new record is displayed below the one being entered. Is it possible to hide the new record from appearing and it only being displayed when a button is selected or enter is pressed on the last field.
 

SetFocus to a specific record in a continuous form from another form

Preview
I have a tabbed continuous form from which I double-click on a record and displays all the details of the record in a separate form. When I close the form, I can go back as far as opening up the continuous form but focus is set on the first record with the code below:

Private Sub Form_Close()

DoCmd.OpenForm "Switchboard"
With Forms("Switchboard")
!tabTCN.Value = !Listing.PageIndex 'open the tab for TCN listing
End With

End Sub

How can I can close the form and setfocus on the same record I double-clicked on