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