Continuous Form Select Record
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
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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
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?
How can I get the screen position of a control for the current record in a continuous form?
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….
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
.Selection.Text = (CStr(Forms!FormName!FieldName))
Is there a way to reference the record in which the button pressed?
Private Sub Form_Close()
!tabTCN.Value = !Listing.PageIndex 'open the tab for TCN listing
How can I can close the form and setfocus on the same record I double-clicked on
To illustrate my problem, my subform currently displays as follows:
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.
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.