replicate number on many rows

[sha7jpm]

entering new records

each record will have the same school number.

any way to replicate this school number for each record in a form, rather than type it for each new pupil record...

at present the form is a query as the user has to type in the school number to check whether the school is already in the database.


ta

John

 

[Dave Eyley]

I have noticed that when you have forms with subforms and the primary fields are the Master/Child links, if the child link is included in the subform datasheet then it is filled in automatically for each new record.

Can you use this in your form?

 

[Rich]

Post details of your db structure, it sounds suspect

 

[IfButOnly]

Can you just put the school number into the fields default value property.

 

[sha7jpm]

to all

many thanks for your help,

the actual problem is affecting one of my colleagues databases, so I will give him your pointers and see how he gets on and get back to you all if no joy.

thanks

John

 

[jfskinner]

Hi there,

I am the colleague to whom sha7 is referring.

I have tried putting the school number in the default value field but when entering data in that record the default value disappears and populates the next (empty) record!

How can I make the default value stay in every record??!!

Any assistance would be appreciated!

Thanks, John