Unbound & Bound

[AmyGotz]

Hi everyone!

Does anyone know of a way that a field can be unbound under certain conditions and yet bound under different conditions? What I mean is this...
I have a pretty complex Access database going on. The main focus of the database is companies. One of the features that the users are asking for is the ability to have a form that can either be left blank (if the company doesn't exist yet in the database) or can be populated with whatever data is available.
I have been trying to no avail to come up with a way for the fields to be able to be unbound but at the same time be able to be populated with data should data already exist.
Bear in mind that a report will ultimately be run off of this form. That may limit what I can do.

Thanks in advance!!!

 

[Parker]

Excuse my possible ignorance but why do you need a blank form for a non existent entity?

In theory it should be possible by creating a form with the, necessary, unbound controls on it and creating an If loop (or a series of) in VBA.

The exact syntax for this shouldn't be difficult to work out but I can't for the life of me work out why you would need to do this. A form dose not need to be populated just to exist and if the company record doesn’t exist why you would need to call the form in the first place in order to see it vacant beats me?????

No I must be missing something. Please explain

 

[Uncle Gizmo]

The problem is if the form is bound to the table, Then it will always show records unless you filter for a particular records. If there are no records that match the filter then the form would be blank wouldn’t it?

If you want a form to be blank for data entry then you can set the Forms Data entry property to yes.

Have a look at this example “One Form Example”.

 

[Pat Hartman]

You should be able to have the form bound. All you need is to use a query as its recordsource rather than a table. The table can use a left join so that if company data is not available, the company controls will be empty but if there is data, the company controls will be populated.