A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Bound Fields



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old April 18th, 2008, 04:35 PM posted to microsoft.public.access.forms
George
external usenet poster
 
Posts: 883
Default Bound Fields

In my database I have two tables:

T-Personnel Data and T-Annual Training used to track how many days my
guardsmen deploy each year.

I created a form F-Annual Training Summary that has the following fields:
Last Name, First Name, Rank, Social Security and all the fields are filled
in when the form opens.

I have a macro button next to each name so when you click on it , it opens a
pop-up form F-Annual Training which is used to enter each persons tour of
duty Start - Stop dates. The form opens based on a Query so that it only
shows their records.

When I created the pop-up form F-Annual Training I didn't want the user to
have to fill in any of the fields such as Last Name, First Name just the tour
of duty Start -Stop dates, so I bound them to the same fields in F-Annual
Training Summary.

This is my problem - When I look in the table that stores the data, T-Annual
Training, the only data in the table is the Start - Stop dates, The info from
the bound fields, Last Name, First Name does not flow over into the table.

Is there and easy fix for this - my programming skills are limited...

George
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:38 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.