Topics Search

Continuous Form Select Record

Continuous Form Select Record
Views: 110
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:

Similar posts...

 

Multiple Record Selection on a Continuous Form

Multiple Record Selection on a Continuous Form Icon
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

No Current Record error - Continuous Form Icon
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

Get position of record in continuous form Icon
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?
 

Create a continuous form using data from a table

Create a continuous form using data from a table Icon
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

populate word template from a continuous form Icon
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

Updating specific record on continuous form Icon
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?
 

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

SetFocus to a specific record in a continuous form from another form Icon
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
 

Hiding a new record in a continuous form

Hiding a new record in a continuous form Icon
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.
 

Continuous form with horizontal and vertical records

Continuous form with horizontal and vertical records Icon
I am building a continuous subform that needs to display records from a single table both horizontally and vertically.

To illustrate my problem, my subform currently displays as follows:

Record 1
Record 2
..,,

I would like it to display as follows:
Record 1 | Record 2 | Record 3
Record 3 | Record 5 | Record 6
.

I know that I can use print preview to set the number of columns, however I am trying to modify the display of the form on the screen, rather than the display of the form on paper.
 

Continuous Form- Single click to update multiple records within record

Continuous Form- Single click to update multiple records within record Icon
I have a continuous form that is selected by combo boxes in the header. The filtered continuous forms display the different Rooms for a particular Day and session. The rooms do have different presenters, but to keep it continuous, I have used common records and checkbox tallies to calculate the status of each room, I.e a % of confirmed Processed presenters.

From this continuous form I am also able to Send Folders around the network.

Each record for all sessions has a Status field that is a text box defaulted to "Open". This Signifies that each session is still open and receiving files.

Once the session folder has been sent to it's destination, I am after a way of toggling a button that will change the Status Field of each record for that room to "Sent".

This will tell the OP who might be processing presenters from the processing form that the session has been sent and to contact admin. It will also give the sent status for the continuous form for each record.

I have looked at all things continuous, and have not found a method to click and change all records to "Sent" for each individual Room Session. I am a bit confused about the finer workings of a continuous form, although everything is working well with what I have learn't so far.