Help with subform navigation.

[calvinle]

Hi,

I have created this linked table in subform, and I wonder if it's possible to do the following things:
1/ When enter new record "Pourcentage", pressing enter will enter the record instead of tab.
2/ In the subform, if you look at the left completely, there is a column with the triangle thing with the *. Is it possible to hide that?

View attachment Test.zip

Thanks.

 

[RainLover]

A couple of hints.

The Combo cboTeacher should have column widths of 0, 2.5. The zero is important as this is the way you hide the primary key. It is this key that you need to search with plus other things. Not the name as you have it because the name is not guaranteed to be unique. After all this is why we have Primary key. The user will never see the Primary Key because you keep hiding it like we have just done.

To get rid of those thing on the Sub Form, that is if I understand you correctly is to use "Continuous Forms" rather than Datasheet view.

If I got it wrong please post back with how when where etc.

 

[calvinle]

Hi,

As per your hint, i did set it to 0;2.5 even i quite don't understand how that will help for my case, but it might be useful for my future project.

However I want my data to be in a table(datagrid) so the user can enter the data directly in. I tried the continuous but it shows 2 long row which is not how I want.

This is how I want it to look like, just the layout:

 

[RainLover]

The first issue.

If you check out how your tables look under the Relationships view you will see that the ContractID_PK is linked to tblFund via the ContractID_FK.

All of your forms should be joined in this manner. This is part of Normalisation. I can see that there is more to come but this bit so far is good. Remember it is the Primary that is unique. The Primary also creates a field on which to join to other tables.

I am sure you will catch on as we go.

I will post this before moving onto the next part. Back soon.

EDIT

I found a big mistake.

The Primary needs to be Autonumber.

This is the way you create a unique identifier. Automatically. You do nothing. No Code No help whatsoever

 

[RainLover]

The attached is something a little better than what you had with Continuous forms.

I hope it helps. I have little experience with 2007 so finding my way around is tricky for me. Perhaps someone else can help.

I did notice that you changed a few of the properties of the form. As long as you know what and why you are doing then fine.

I created a new subForm which you can look at and throw away when you are finished.

Please let me know how things go.