Continuous Forms custom view for each record

I have a form in continuous forms view and I need to rather view or hide certain controls based on other criteria, but only for those records and not all records. For a simple example (not an actual example, just ease of understanding one), lets say I have a form with a checkbox field and a field called Control1 (amongst other fields) viewed in continuous forms view. If the checkbox is checked, I need to show control1 for that record, if it is not checked, hide Control1. So lets say that the first record in the form control1 is visible, the second record it is hidded, 3rd and 4th it is visible again and so on.

Everything I have tried so far shows or hides my control on all records and not just the ones I need them to. Is this possible and how would I acomplish this? And by the way I have looked at conditional formatting already, and it just doesn't have the ability to accomplish this in the way I need, so other suggestions are needed

Sponsored Links:

Related Topics

images in continuous forms
Does anyone have a procedure for adding different images per record in a continuous form view, using a2007.


Continuous forms records missing
I have a form (frmBreakdown) whose default view is Continuous Forms. It is populated from tblBreakdown. When it opens it opens to New Record, but you are still able to scroll up to see old records.

It has been working fine for over a year, but yesterday when i opened it, there were no old records. It only shows the new record, and the buttons at the bottom show that there is only 1 record.

I checked the table and all the records are still there, and i can still run reports from it, but none of the form settings have been changed so i cannot figure out why all of a sudden all the records are missing.


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


Customisation of dynamically populated forms
I have a series of forms and subforms which cascade to dynamically create a checklist form of certain questions and answers dependant on the choices selected by the user.

This works by dynamically populating the form with whatever questions are required from the relevant tables

The check-list actually works quite well however I can only get the form to display 1 question at a time in single form view or all questions at a time for continuous form view. I do not want to use datasheet view

So therefore is there more customisation I can do with continuous view in code to show a certain number of questions per page for example, I don't like the scroll options I want to do everything with command buttons?


Customisation of dynamically populated forms
I have a series of forms and subforms which cascade to dynamically create a checklist form of certain questions and answers dependant on the choices selected by the user.

This works by dynamically populating the form with whatever questions are required from the relevant tables

The check-list actually works quite well however I can only get the form to display 1 question at a time in single form view or questions at a time for continuous form view. I do not want to use datasheet view

So therefore is there more customisation I can do with continuous view in code to show a certain number of questions per page for example, I don't like the scroll options I want to do everything with command buttons?


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


Continuous Form- Single click to update multiple records within record
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.


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


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


Creating Custom Forms
In this lesson, you will learn how to use Access forms for data input and editing. Forms let you go one giant step beyond regular data entry. In short, forms provide custom interfaces that let you work with data in the most natural way.
For example, if you are working with an employee database, you can create a form that matches an employee record. Depending on your company, you may have several different departments that use employee records. Using Access forms, you can create a custom interface for each department. Each department's form, in turn, will present only those fields that employees in that department need to use.


Changing form view from Continuous to single
I have a form with a sub form. In one circumstance - where an employee already exists - I want the sub-form display to be continuous forms; in another situation, that of inputting a newemployee, I want the sub-form display mode to be single form ie the user must only be allowed to enter one record.

I have tried to set DefaultView from VB but get an error saying it must be set in form design mode. I have tried setting AllowAdditions to No, but this results in not being able to input any data into the blank record which is displayed on form opening.

Is there a way to switch display modes for this sub-form dynamically, this time with the sub-form DefaultView set to SingleForm, anduse it for the special situation of entering a new employee?


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


Linking subforms
I have two forms, both based on the same database. Form1 is in single form view, Form2 is in datasheet view. I am trying to combine the two forms. I have created a blank form and added the two forms as subform controls. Now I need to make sure that when I click on a record in the datasheet subform (Form2), the same record is displayed in the single view subform (Form1). To that end, I have created a text box to track the record number of subform (Form2). When I try and link the single view subform (Form1) master and child fields, I am getting the error - cannot build links between unbound forms.
NB - I have tried a split-form, but that is not acceptable for other reasons.


the expression you entered has a field, control, or property name that...
Wasn't sure about the title for this topic.

I have a continuous form with a list of records. I use a button next to each record to view the selected record in more detail.

So that's one continuous form to view another single form.

The code on the button click event is

1) DoCmd.OpenForm "FRMProgramsDetails", , , "[ProgramID] = " & Me.ProgramID
I'm getting the runtime error message:
The expression you entered has a field, control, or property name that Microsoft Office Access can't find

This suggests to me that the single form either uses a query with out ProgramID field or there is a control on the form without using the ProgramID. But ProgramID is defiantly being used in both accounts and the name of the control on the single form (FRMProgramsDetails) is called ProgramID.

In fact both the controls on both forms are names ProgramID. ProgramID is set to a PKset to AutoNumber data type.


Hyperlink on forms
I have two forms - one single form view, one continuous forms view. The single form has a tab control.

I have a hyperlink text box control on the continuous form and an identical one on the tab control of the single form.

The hyperlink on the tab control only works if the sub-menu item "Hyperlink Open Hyperlink" is used. If I click on the control, the system inserts a "#" before and after the url and then does nothing else. If I put the text box control in an area of the form outside of the tab control,


how to get auto numbering on continuous form records
I have a form of view type "continuous forms" that is returning records based on a query, and I want the records to have a number label like 1, 2, 3. in the order listed:

Is there any way to generate a label or textbox automatically there?


how to get auto numbering on continuous form records
I have a form of view type "continuous forms" that is returning records based on a query, and I want the records to have a number label like 1, 2, 3. in the order listed:

Is there any way to generate a label or textbox automatically there?


continuous forms
Continuous Forms

I am having a little trouble with continuous forms. I have a stores database, I have a form which shows every item with a serial number in one locations. I have a check box next to each item. With a text box in the heading what I would like is when a ser no is entered into the text box a tic to appear in the check box next to the item. But when the form is closed and opened then check boxes to be in unchecked.

No sure where to start on this one


Scrollbar/Slider Bar on a Continuous Form
I am using the Microsoft Forms Scrollbar 2.0 ActiveX object. I have embedded it in a continuous form. I have connected the on updated event to populate a bound text box. Problem is my scrollbar, which appears on every visible row, moves in unison.

If I scroll on the first record, all the rest of the scrollbars scroll. only the text box on the first record updates though.

If I scroll on the 2nd record, the same thing, they all move, but only that record updates. So functionally it is doing what I want it to do, but cosmetically it looks crazy to see those scroll bars moving.

I tried binding the scroll bar to a Control Source, but Access would allow a bound ActiveX control on a continuous form.

I'm willing to consider anything from a fix to starting from scratch, whichever is the simplest and the quickest.