Re: Jumping records

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Thu, 29 May 2008 07:07:00 -0700, Jack at Relaxed
<JackatRelaxed@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

John - many thanks for this. Each record in my form is based on a Contact who
is being assigned an organisation (which in turn has been assigned an
address) and a job type (one organisation can have many addresses which is
turn can be assigned to many contacts and one job type can be also assigned
to many contacts). I do use combo boxes as a way of assigning these
organisations and job types to the contact. I mis-lead you by the term
look-up - I don't use look-ups in tables, I create separate tables with the
values and then create a realtionship, so my tbl_Contact has a 1-many
relationship with my tbl_Address which then has a -many relationship with
tbl_Organisation etc. I have built many databases for may users that follow
this exact structure and have never come across this problme before!
I heop thsi has made it a bit clearer now. Thank you in advance.

IMA's suggestion may be on target - try setting the Form's Cycle property to
"Current Record" so that tabbing around will stay on the same record.

It could also be form corruption of course; has this user's database been
compacted and repaired? Do you have any plans to split the app? Doing so would
be cheap insurance inasmuch as you could have a "clean" frontend backup
available and needn't worry so much about losing your data to corruption.
--

John W. Vinson [MVP]
.

Relevant Pages

  • Re: Jumping records
    ... Thanks John, yep, the Current record option done as per previous thread - ... turn can be assigned to many contacts and one job type can be also assigned ... I do use combo boxes as a way of assigning these ... It could also be form corruption of course; ...
    (microsoft.public.access.forms)
  • Re: db_owner
    ... and assigned him to the db_owner role to one of our user created databases. ... When I set up an odbc or .udl using this Windows domain user credentials how ... db_owner or would assigning a combination of the other system roles ...
    (microsoft.public.sqlserver.security)
  • Should i learn Access?
    ... I know very little about databases but need to create ... It would be a relatively simple DB, where employees ... with permissions and assigning them, ...
    (microsoft.public.access.gettingstarted)