still confused, can someone help

[val_87]

Oh and I would rename the consent forms data - those / and spaces in names will give some headaches later on.

Remove it from where? Sorry.
Attached is the main form everything will start from.
What is bugging me is that background behind it the blue one ... or it is white sometimes. How do i remove it? So that in form view it is just the form.

From this form all operations start when data is searched, then user will click and open a form with subform for personal and testing. So i also need to lock the data inside the main form so it can be edited but just looked and clicked at.
But first i want to get rid of that damn background, it does not look pretty!

 

[Minty]

Remove it from where?

Rename the fields / table not remove

Your attachment isn't there I'm afraid

 

[val_87]

Rename the fields / table not remove

Your attachment isn't there I'm afraid

That is a sub-form. So how do i get this damn background away from the main form so that just main form remanis and none of that stuff at the back?

Its actually nice to see something forming out of it!

 

[val_87]

Rename the fields / table not remove

Your attachment isn't there I'm afraid

Sorry here is the main page where i am seeking to remove background.

 

[Minty]

if you are describing the blue behind the title, click the form header and open it's properties - I think you will see a Back Colour property - play with that.

 

[val_87]

if you are describing the blue behind the title, click the form header and open it's properties - I think you will see a Back Colour property - play with that.

No i mean the full blue behind the actual table.... I am also havin'g trouble linking the forms together to open it ... says can't be linked or smth, i will meditate on that and try and figure it out!

 

[Minty]

On the sub form - I think that is the highlighting to show you which record is selected.
I don't normally use datasheet view - so I'm not sure tbh.
I normally create a continuous form that replicates a data sheet - it's more flexible in layout and use.

 

[val_87]

On the sub form - I think that is the highlighting to show you which record is selected.
I don't normally use datasheet view - so I'm not sure tbh.
I normally create a continuous form that replicates a data sheet - it's more flexible in layout and use.

I ran in to a issue, on main Navigation form im trying to make a command button, that when selected on record takes to that record on the other form with patient info and tests... It's says you have chose two forms that can not be linked together... you must have at least one field that can be linked together ....

 

[Minty]

I'm not familiar with the inbuilt Navigation forms I'm afraid - I always build my own.
The premise though will be that you either need to store the current record ID in the main form, or you will have to write some code attached to the command button to get the record ID by referencing the form and current record that has the data on it.

There are lots of examples on here - and this page http://access.mvps.org/access/forms/frm0031.htm is invaluable for getting the syntax correct.